| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change the color of a cell or text with an if statement
use formula is =F6<$B$1
It's the same condition that causes the IF() formula to return Past Due "Oddcarout" wrote: =IF(D6="Yes", "Complete", IF(F6=$B$1, "Current", "Past Due")) I want it to be red if "Past Due" for the conditional I have Formula is ="Past Due" but that does not work. thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change Cell Color Based on IF Statement | Excel Worksheet Functions | |||
| Change text color in a cell automatically | Excel Discussion (Misc queries) | |||
| Macro to change cell text color | Excel Discussion (Misc queries) | |||
| text color change in cell reference | Excel Discussion (Misc queries) | |||
| Cell text color change | Excel Discussion (Misc queries) | |||
Hybrid Mode
