View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Neon520 Neon520 is offline
external usenet poster
 
Posts: 129
Default Conditional Formatting-If Col A="" then Col C = Red in color

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