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

  • Thread starter Thread starter Neon520
  • Start date Start date
N

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
 
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.
 
Hi FSt1,

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

Thanks,
Neon520
 
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
 
Back
Top