| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF formula with conditional formating help please
Green 95%-100%
Yellow 85%- 95% Red <85% ....A ....B 100% 70% I would like to highlight cells with a color the cell meets certain criteria. I think I need to use an IF formula . In my example here ...if B2 is within 85%-94% of A2 then the answer would be "yellow" but if B2 is < 85% of A2 then it would be "RED". I thought I would plug this formula into the conditional format of the cell in order for it to highlight the cell aproppriately but I may be approaching this all wrong and would love some help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formating and Formula | Excel Discussion (Misc queries) | |||
| Conditional Formating Formula | Excel Discussion (Misc queries) | |||
| if, then formula with conditional formating | Excel Worksheet Functions | |||
| If Formula or conditional formating | Excel Discussion (Misc queries) | |||
| Formula for Conditional Formating - Help! | Excel Worksheet Functions | |||
Threaded Mode
