| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting part 2
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? *** The driver being Today()-J5. Conditon 1, Today()-J5 <=7 Conditon 2, Today()-J5 0 Conditon 3, Today()-K5<1 Appreciatively, Arturo |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting part 2
=IF(AND(TODAY()-J5<=7,K5<1,TODAY()-J50),TRUE,FALSE)
__________________________________________________ ___________________ "Arturo" wrote in message ... 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? *** The driver being Today()-J5. Conditon 1, Today()-J5 <=7 Conditon 2, Today()-J5 0 Conditon 3, Today()-K5<1 Appreciatively, Arturo |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting part of text | Excel Discussion (Misc queries) | |||
| Subtotals & Conditional Formatting Part 2 | Excel Worksheet Functions | |||
| conditional formatting "if part of cell contents contains string" | Excel Worksheet Functions | |||
| Conditional formatting for part of a cell | Excel Discussion (Misc queries) | |||
| Conditional Formatting - part of cell only | Excel Discussion (Misc queries) | |||
Hybrid Mode
