Forum Discussion

Copper Contributor

Nov 19, 2019

Conditional Formatting Using Percentages

I need to highlight a cell that is 10% over another cell. example B1 is $100 B2 is $110 i need B2 to be highlighted. since its 10% higher. I know how to do this if put in with exact ...

Conditional Formatting

excel

PReagan

Bronze Contributor

Nov 19, 2019

Hello MiMiMarie,

With the conditional format applied to only B2, select B1 and B2. Then select the format painter (looks like a paint brush in the home tab) and select your entire list. This will apply your format to every other cell starting at B2.

P.S. You may double click the format painter to use it multiple times

MiMiMarie

Copper Contributor

Nov 19, 2019

That didn't work. It only copied the original format with the original cells in the format. PReagan

PReagan
Bronze Contributor
Nov 19, 2019
MiMiMarie

Make sure that the conditional format in B2 does not use absolute references. The conditional format in B2 should be =B2>=B1*1.1, not =$B$2>=$B$1*1.1