Conditional formatting using a formulaClosed

Question

I would greatly appreciate any and all help, please and thank you so much in advance!

I am trying to create a conditonal format on a row of cells based on a formula.  I would like to color the cells in Row A, if Row A/Row B>20%.

Thanks again for any advice.

TrowaD · Answer

Hi analystquestion,

I think you are confusing rows with columns.

Formula is:
=A1/B1>0,2

Best regards,
Trowa

analystquestion · Answer

Yes, I was confusing rows with columns. :)  Thanks.

I tried entering in the formula as the above (into the conditional formatting formula space) and it didn't conditional format any cells, however I know that some cells should have been.  Can I give you additonal information that might help?  Say, for example, I have a list of items with store count changes from this year to last year.  I want to highlight the column labeled 'Str count this year', if the difference is greater than 20% from the store count from last year.

Store Count this year 3,267 
Store Count Last year 2,668
*This is a 22% increase, so I would want to highlight this cell blue.

Thank you so much and I truly appreciate any and all help you can provide.

TrowaD · Answer

And I'm confused with the percentages :)

 Formula should be:
=A1/B1>1,2
 
Best regards,
Trowa

analystquestion · Answer

It's not working.  Two things:
-Does it matter that both columns have formulas in them?  
-The formula we would normally use to find % change would be A1/B1-1

Thanks again for any additonal insight.

TrowaD · Answer

Formula's shouldn't matter. 

Not sure what is going on.

In the following file:
http://www.ge.tt/7hgai9o/v/0?c
A1: =100+50
B1: =50+50
C1: CF formula =A1/B1>1,2
As a result C1 is colored blue.

What is different in your file?

analystquestion · Answer

Thanks for the file.  Rather than creating another column for % change, I'm trying to color the cells that already exist.  In your example above, I would need to color cell A1, if the difference between A1 and B1 is greater than 20%.

Thank you.  Maybe it's not possible without creating that additional column...?

TrowaD · Answer

Then you need to select A1 instead of C1 when applying conditional format.

Conditional formatting using a formula

7 responses

Similar discussions

Subscribe To Our Newsletter!