change cell color within a formula...
Take a look at Format|Conditional formatting.
You can specify up to 3 conditions (in xl2003 and below) and specify the
colors/formatting that you like.
rdeap wrote:
I have this formula working in me Excel document
=IF(A1=39295; "OK"; "Not OK")
It works! It is a big deal for i´m not a programmer!
But what I need, instead of "OK" and "NOT OK" is to change the cell color.
OK - black #000000
NOT OK = orange #FF6600
Is this possible?
Thanks.
--
Dave Peterson
|