Quote:
Originally Posted by Fuzz
If B1 gets a value when A1 is Y, otherwise it stays blank, can't you just do a conditional format on B1 being blank or not?
|
I only want the cell colour to change when B1 is blank and A1 is Y. A1 can also be N and when A1 is N, B1 will be blank and that is acceptable and I don't want the cell highlighted.