| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional format color is set correct, yet color will not change
For Red:
Condition1: Formula Is =AND(ISNUMBER(A1),A1=14) For Green: Condition2 Formula Is =AND(ISNUMBER(A1),A1<15) If I put in 01/01/2009 - 01/21/2009 cell DOES turn red. If I change the second date(01/21/2009) (20days) to 1/04/2009 ( 3 days) the cell Stays RED or if I have a green cell IT STAYS GREEN when the dates are altered.. Is this a one time shot?.. Any ideas And I apologise if I have posted this more than once . I am over my head and have reached out on 3 topics... Thanks for understanding Mark |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Checkbox to change background color, font color and remove/ add bo | Excel Discussion (Misc queries) | |||
| Conditional format: change row color based on cell value | Excel Discussion (Misc queries) | |||
| change color of entire row by use conditional format | Excel Worksheet Functions | |||
| How do you use conditional format to change a bar color on a char. | Charts and Charting in Excel | |||
| Conditional Format: Expired dates wanting cell to change color | Excel Discussion (Misc queries) | |||
Threaded Mode
