| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In excels if function can i ask excel to shade cells on result?
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW CAN I CONVERT A NUM IN WORDS (EXCEL) | Excel Discussion (Misc queries) | |||
| VBA | Excel Worksheet Functions | |||
| convert numbers to text | Excel Discussion (Misc queries) | |||
| I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
| Amount or Numbers in Words | New Users to Excel | |||
Linear Mode
