Hi,
I'm trying to setup conditional formatting that will change the colour of a cell depending on text entered in it.
I would like the cell to be Red if the name Sue is in it. I would like it Green if the word Spare is in there and Yellow if any other name is in there. Is this possible as i'm tearing my hair out trying to get it to work !!!!
Many thanks in advance for any advice.
Select the range to highlight, let's assume A1:A10
Conditional Formatting
New Rule
Use a formula to determine...
=(A1="Sue")
format as red
=(A1="Spare")
format as green
=AND(A1<>"",A1<>"Sue",A1<>"Spare")
format as yellow
Format as required
Use Format painter (paintbrush icon) to copy to other cells
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks