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

Conditional formatting.

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Nick" wrote in message
...
Is it possible to change the background color of a cell or text color if a
certain criteria is met?

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.
--
Therese


"Nick" skrev:

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

yes

select the cell and go to format conditional formatting

"Nick" wrote:

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

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.

"Nick" wrote:

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