Forum Discussion
Conditional Formatting - Color Fill
Hi, I have set up a conditional format to change the color of a cell based on the value of it. The value is Yes/No and the format is to fill the cells Green/Red. This works fine, however excel do...
HarryE ,
Here are at least couple of threads how to do calculations based on conditional formatting color (VBA).
At the same time why don't you COUNTIFS() all Yes and No?
