| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting
Just add another condition to the AND function:
=IF(AND(TODAY()-J5<=7,TODAY()-J50,K5<1),TRUE,FALSE) HTH, Elkar "Arturo" wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting
You shouldn't need the IF(...,TRUE,FALSE).
You should get the same result from =AND(TODAY()-J5<=7,TODAY()-J50,K5<1) -- David Biddulph "Elkar" wrote in message ... Just add another condition to the AND function: =IF(AND(TODAY()-J5<=7,TODAY()-J50,K5<1),TRUE,FALSE) "Arturo" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Linear Mode
