Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Cell J5 is conditionally formatted as
=IF(AND(TODAY()-J5<=7,K5<1),TRUE,FALSE) How would I add an additional condition of Today()-J50, then if all three conditions are met, turn font red? Appreciatively, Arturo |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting/VBA | Excel Discussion (Misc queries) | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Conditional Formatting | Excel Worksheet Functions |