Conditional Formatting-If Col A="" then Col C = Red in color

[Neon520]

Hi everyone,

This doesn't have to be done in VBA, but I just thought that it might not be
able to get done in regular way.
What I essential want is if Col A or Col B is Blank, then highlight Col C
and D to Red. It's just a way to pull the user attention.

I don't know how to do this in regular way, since the conditional Cells are
different from the Formatting Cells.

Thank you,
Neon520

 

[FSt1]

hi
regular way...

formula is.....=OR($A$1="",$B$1="")......pick your color

regards
FSt1

 

[Per Jessen]

Hi

No need for a macro.

Select C2 and goto conditional formatting > Condition 1: Formula is >
=AND($A2="",$B2="")

Format as desired.
Use the format painter to format the desired range.


Hopes this helps.

 

[Neon520]

Hi FSt1,

Is there a way to go over the three conditional formatting limit without
using VBA?

Thanks,
Neon520

 

[Gord Dibben]

Not in versions before 2007

Why do you need more than three conditions?

Not for the example you posted originally.


Gord Dibben MS Excel MVP