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

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
 
F

FSt1

hi
regular way...

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

regards
FSt1
 
P

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.
 
N

Neon520

Hi FSt1,

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

Thanks,
Neon520
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top