Hi all,
I have put in a random formula in cell A2 down to A13 for example purposes
My query is hopw can I setup a CF in column b2 onwards to say: if cell a2 has a value, (ignore formula) and b2 is blank, highlight b2 in red. I want to apply the formula to the whole column (A) but if a100 has no value, I don't want b100 to highlight in red...
thank you
Bookmarks