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
regular way...

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

regards
FSt1

"Neon520" wrote:

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.

---
Per

"Neon520" skrev i meddelelsen
...
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 FSt1,

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

Thanks,
Neon520

"FSt1" wrote:

hi
regular way...

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

regards
FSt1

"Neon520" wrote:

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

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

On Wed, 21 Jan 2009 10:49:01 -0800, Neon520
wrote:

Hi FSt1,

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

Thanks,
Neon520

"FSt1" wrote:

hi
regular way...

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

regards
FSt1

"Neon520" wrote:

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