In my spreadsheets there are several cells that depend upon each other and
when one of them is not filled out I have to go back thru the sheet and check
for a blank cell. My question is can I use conditional formatting or a VB
coding to color the cells background that are not filled in if another cell
that depends on it is. Or use something like IfNull to color the background
if the cell is unused.