alert

[nyn04]

is there a way to have a cell change it color when a condition is met
let say its calculating a certain number that changes when that number
crosses a certain limit I will like the cell to turn red

any ideas

thanks

 

[Guest]

Probably the simplest solution to your problem is to use the "conditional
formatting" feature.

Select the cells that you want the formatting to apply to.
Go to Format > Conditional Formatting ..
In the field for "condition 1" set the conditions as follows:
"cell value is.." "Greater than" and then fill in the limit that you mentioned
Then click on the "Format.." button, and then click on the "Patterns" tab.
Simply select the color for the cell that you want when the condition you set
is met.

I hope that this helps