View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gordon Gordon is offline
external usenet poster
 
Posts: 19
Default In excels if function can i ask excel to shade cells on result?

"The Badger" <The wrote in message
...
I have created an "if" function with two results "up" or "down".

I want to automatically highlight the "down" results so they can be
tracked.
Can the IF function do this - current formula is =IF(j1j2,"up","down").

Thanks for your help.

The Badger



Conditional Formatting.