Conditional Formatting Using Percentages

Question

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 numbers but i want it done in percentage for

subodh_tiwari_sktneer · Answer

MiMiMarie&nbsp;You may try the following formula for making a new rule for conditional formatting...=B2&gt;=B1*1.1

mimimarie · Answer

Subodh_Tiwari_sktneer&nbsp;&nbsp;WORKED GREAT!!!!&nbsp;Next Question:&nbsp;How can I get it to work for the rest of my cells so i don't have to input it for every single one.&nbsp;example:B1 $100B2 $110&nbsp; &nbsp; &nbsp; =B2&gt;=B1*1.1B3 $200B4 $220&nbsp; &nbsp; &nbsp;&nbsp;=B4&gt;=B3*1.1B5 $300B6 $330&nbsp; &nbsp; &nbsp;&nbsp;=B6&gt;=B5*1.1&nbsp;I need B2 to change, B4 to change, &amp; B6 to change. I can't copy the formatting because it only copies the original formatting and doesn't continue it down the line with new cells. Any suggestions?&nbsp;I have 10 workbooks to do this to with about 200+ cells and I dont want to spend weeks on this.&nbsp;

preagan · Answer

Hello&nbsp;MiMiMarie,&nbsp;With the conditional format&nbsp;applied to only B2, select B1&nbsp;and&nbsp;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.&nbsp;P.S. You may double click the format painter to use it multiple times

mimimarie · Answer

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

preagan · Answer

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

Forum Discussion

Conditional Formatting Using Percentages

8 Replies

Resources