In excels if function can i ask excel to shade cells on result?
 

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

In excels if function can i ask excel to shade cells on result?
 

Use Formats/Conditional formatting:
Select cells containing your IF function
Formats/Conditional formatting, cell value equals "down"
Choose a format (say red background)

Regards,
Stefi


€žThe Badger€� ezt Ã*rta:

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

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.