C
Carol
Hello.
I have conditional formatting set as: If cell value is equal to or less than " " (blank) then color it green.
The cell also has a formula in it that pulls a "yes" or "no" response from a question on a different sheet in the workbook.
I'm finding if the answer comes in Yes, the color in the cell clears (which is exactly what I want it to do), but if the answer comes in as No, it does not clear!
Can you tell me what is causing this?
Thank you!
I have conditional formatting set as: If cell value is equal to or less than " " (blank) then color it green.
The cell also has a formula in it that pulls a "yes" or "no" response from a question on a different sheet in the workbook.
I'm finding if the answer comes in Yes, the color in the cell clears (which is exactly what I want it to do), but if the answer comes in as No, it does not clear!
Can you tell me what is causing this?
Thank you!