VBA Conditional Formatting with Blank Cells

[Rob.Marchel]

Hi All,

I'm trying to conditionally format blank cells within a large list of button operated VBA conditional formatted cells.

I can't get blank to work.

Please Login or Register  to view this content.

Thanks in advance.

Rob.

[humdingaling]

are you trying to make cells with data BLACK?

also whats UCASE meant to do here?

[humdingaling]

Please Login or Register  to view this content.

^^ this is for BLANK

make colorindex = 1 for BLACK

[Rob.Marchel]

Hi Humdingaling,

Please Login or Register  to view this content.

Slight change, but got me there in the end.

Thanks all!

[humdingaling]

knew it was one or the other

thanks for the rep