I have a column of blank cells. If I type something into a cell, I want the cell immediately below that one to turn red. Any ideas for conditional formatting help?
follow this steps
select cell b1
set conditional Format, say for Column B
apply to Range: B2:B (>it will later correct to B2:B999 or max rows)
=not(isblank(b1)) >>fill RED
if for some reason, like not selecting B1 at the beginning the formula (upon inspection) is different, pls correct to ...B1...