Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Here is what I would like to do:
This is a 3 Condition on an entire row. Row: A Condition 1: If A5 is inputted with any date - then entire row becomes Bold Blue Text Condition 2: Then when any date is entered in J5 - the entire row changes to red text Condition 3: When any date is entered into cell L5 - the entire row changes to bold black. The problem is - it is only following condition 1. I tried various formulas such as =if and and, but I can't figure out the correct string. I was thinking perhaps an formula based on if condition 1 was complete and then condition 2 is true. Help... Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Deferring conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional Formatting: "handwritten" circles? | Excel Discussion (Misc queries) | |||
cannot use ISEVEN or ISODD functions in Conditional Formatting | Excel Worksheet Functions | |||
Formula Dependant Conditional Formatting | Excel Discussion (Misc queries) | |||
Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) |