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?

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 :

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

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 ?

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