MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Formatting cells by criteria


Posted by Ian on January 17, 2002 1:26 PM

How can I colour cells by matching a criteria ie if I type in "apple" how can I get it to automatically go green?
Does this require a macro? if so, any suggestions?
Thanks


Posted by Chris D on January 17, 2002 1:33 PM

You could try conditional formatting....

Highlight the range of cell you're interested in, then :

format
conditional formatting
cell value is equal to "apple"
format
patterns
pick a nice shade of green
okay
okay

and your cell should be formatted to green on the condition that the cell value is equal to "apple"

is this what you had in mind ?
Chris

Posted by Chris D on January 17, 2002 1:35 PM

highlight the range of cell" ?

what am I talking about ?

just highlight the cell