I checked Sample2 and like Sample 1 it has CF rules scattered about the whole sheet.
To see what your have,
On the Ribbon, Select Home Tab,
Select Conditional Formatting,
Click on Manage Rules
At the top of the window is a box marked: Show Formatting Rules for:
Scroll this box until you get to: This Worksheet
I show Four (4) rules, all green, applied to Four (4) different ranges of cells.
Also,
If you scroll the box down to Screen 2, there is also a rule there.
Get rid of all these rules.
Select Conditional Formatting,
Select Clear Rules
Select Clear Rules from Entire Sheet
Now recheck Manage Rules and make sure they are gone.
Also most if not all of your cells have Hard Coded Colors in them,
so applying CF appears to do nothing.
You will need to clear all of the Hard Coded colors if you want to
see the CF.
Bookmarks