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.

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.