The formula is entered as conditional formatting rule condition, not into worksheet cell! Select the range with data (e.g. A3:A12), then activate Home menu, select Conditional Formatting and then New Rule (or when some rules are defined, then Manage Rules). For new rule select Use a Formula ... - and now enter the condition formula for left topmost cell of selection (be aware of use $ signs for cell references - in your case it must be $CR, like $E3). Then click Format and set there how cell is displayed when the condition is TRUE, and press OK until done!

Thre is something I am not doing right here.

• Ive tried various methods but in this example I clicked A to select the entire column.
• Home > Conditional Formatting > new rule
• Select Use a formula to determine which cells to format
• Selected the E column ( as that is where the data is)
• Format the cell to turn yellow.
• No cells turn yellow

If I select a single cell A15 for example

• Home > Conditional Formatting > new rule
• Select E15 and =$E$15 appears in the formula field
• use formatting to turn the cell yellow based on the E column which is 56%
• Cell turns yellow

If I do that same formula on a cell that is under 50% then that cell doesnt turn yellow


So on an individual cell the formula that I have entered works. How can I get that to work over Multiple cells, where the % in column E differs (I hope ive explained that correctly)


ive tried using format painter but that doesnt work