e, in
that the colours will change instantly if a cell in Col B becomes blank or
non-blank. In the first sheet you have to run the macro again, or change it to
an event macro.
Regards - Dave.
From: zanderman1...@googlemail.com
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help n
Hi all
I have been working on the following piece of code to identify Blank Cells
and turn them red:
Range("B2:B105").Select
Selection.SpecialCells(xlCellTypeBlanks).Select
ActiveWindow.SmallScroll ToRight:=-1
With Selection.Interior
.P
