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