How di I highlight blank cells in a range
This has been asked before wherein all blank cells in a range color changed to green and solution was given as below
Dim rng as Range On error resume next set rng = range(range("B7"), range("G" & Range("A"&Rows.count).end(xlup).row)).specialcells(xlcelltypeblanks) on error goto 0 if not rng is nothing then rng.Interior.ColorIndex = 4 end if
what i want is that the moment I type in the green cell the color should go bacl to normal.
sample sheet attached