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