change cell color within a formula...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Thanks but it didnt work. Its difficult to me.
I´m using Office2007. I found the conditional format but I dont know how to
use it. It goes all wrong...

///////////////////////////////////

What im tryng to do is to highlight a cell that represents 'today'.
i have H1 to AK1 to change the color (it representes the 30 days for august)

the idea is:
today is orange
not today is black.

///////////////////////////////////

in A1 i have today() >> today 8/8 is 39302

in H1 (that represents 01/08/2007 / 39295) i have:
=IF(A1=39295; "OK"; "Not OK")

in each cell that i want to color, i have a number that represents its day
for august, it goes from 39295 to 9332a (01/08 - 30/08)

Maybe its not this way, isnt it?
For what i looked at the conditional format I could not use my formula...
But thanks anyway

////////////////////////////////////
 
Back
Top