Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting - mutlple formats
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting - mutlple formats
I think you just need to change the order of your conditions. Since your
Condition 3 overrides the other two, it should actually be listed first. That way, only if it is false, are the other two conditions even considered. So, it should look something like this: Condition 1 =$L$5<"" (bold black) Condition 2 =$J$5<"" (red) Condition 3 =$A$5<"" (bold blue) HTH, Elkar "StinkyDesigns" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |