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

[The Badger]

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(j1>j2,"up","down").

Thanks for your help.

The Badger

 

[Stefi]

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:

 

[Gordon]

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(j1>j2,"up","down").

Thanks for your help.

The Badger

Conditional Formatting.