View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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