Can you do a conditional formatting of the adjacent call based on values in
current cell..e.g. if value of A1=0 then B1 cell color should be red