Hi All,
I've been scratching my head on this all morning!
How would I make a cell in column J highlight yellow, if the adjacent cell in column I contains the word "SENT" ?
Thanks so much,
CG
Hi All,
I've been scratching my head on this all morning!
How would I make a cell in column J highlight yellow, if the adjacent cell in column I contains the word "SENT" ?
Thanks so much,
CG
Hi
follow this
select cell in column J go to home--- conditional formatting option ---new rule ---use formula to determine which cell to format -- in type box write --IF(I8="SENT",1,0) -- use format in format tab ---ok
this will solve your problem
later you can select cell which conditionally formatted & go to format painter under home tab , & paste that formatting on required cells
Click on * below if you find this helpful
Thanks,
A
Highlight the cells in column J that you want this to apply to - assume this is J2 to J100, with J2 as the active cell. Then click on Conditional Formatting | New Rule | Use a formula ...
Put this formula in the dialogue box that opens:
=ISNUMBER(SEARCH("sent",$I2))
Click on the Format button, then the Fill tab and choose your colour. OK your way out. Then Excel will adjust the cell references to suit the other selected cells.
Hope this helps.
Pete
-- Accidental post; please see below reply instead.
Last edited by chatguy; 08-19-2013 at 03:29 PM.
Hi Amy & Pete + Others,
Apologies, I should have given more information. It would need to contain the word 'SENT' "as part of" the cell. (e.g.: "SENT 8/15/2013", or "SENT 7/29/13")
So if Cell I6 contained the word 'SENT' as part of the cell, it would then highlight cell J6 in yellow (or cell I99 would affect J99, etc).
Unfortunately the above didn't work -- I did try the above 2 solutions (and thanks for help so far, btw!) where it seemed to incorrectly color the "J-column", when the "I-Column" didn't contain that word -- and didn't color the "J-column" cells in when the "I-Column" did contain that word.
Any ideas that might be able to help get it that far in Excel 2010?
Thx again,
CG
Last edited by chatguy; 08-19-2013 at 03:14 PM. Reason: Clarification
@ amy, just fyi, you dont need...IF(I8="SENT",1,0), CF works on TRUE/FALSE, so all you need is =I8="SENT"
@ chatguy, Pete's formula should have worked. Make sure you have the ranges set properly?
maybe upload a sample workbook?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks