Can I color a cell if a certain criteria is met?

[Guest]

Is it possible to change the background color of a cell or text color if a
certain criteria is met?

 

[Bob Phillips]

Conditional formatting.

See http://www.contextures.com/xlCondFormat01.html

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Guest]

Hi
You can use conditional formatting. Format-conditional formatting, and there
you can make criterias and even formulas that will change the background and
scriptcolour.

 

[Guest]

yes

select the cell and go to format > conditional formatting

 

[Guest]

Yes... Use conditional formatting in the format menu. you can set the
condition for which the colour of either the font or the background or both
can change.