Conditional formatting using a formula

Closed
analystquestion
Posts
4
Registration date
Monday August 5, 2013
Status
Member
Last seen
August 6, 2013
- Aug 5, 2013 at 04:43 PM
TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
- Aug 8, 2013 at 10:18 AM
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.

7 replies

TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
509
Aug 6, 2013 at 10:15 AM
Hi analystquestion,

I think you are confusing rows with columns.

Formula is:
=A1/B1>0,2

Best regards,
Trowa
0
analystquestion
Posts
4
Registration date
Monday August 5, 2013
Status
Member
Last seen
August 6, 2013

Aug 6, 2013 at 10:32 AM
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.
0
TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
509
Aug 6, 2013 at 10:57 AM
And I'm confused with the percentages :)

Formula should be:
=A1/B1>1,2

Best regards,
Trowa
0
analystquestion
Posts
4
Registration date
Monday August 5, 2013
Status
Member
Last seen
August 6, 2013

Aug 6, 2013 at 11:52 AM
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.
0

Didn't find the answer you are looking for?

Ask a question
TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
509
Aug 6, 2013 at 12:02 PM
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?
0
analystquestion
Posts
4
Registration date
Monday August 5, 2013
Status
Member
Last seen
August 6, 2013

Aug 6, 2013 at 01:12 PM
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...?
0
TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
509
Aug 8, 2013 at 10:18 AM
Then you need to select A1 instead of C1 when applying conditional format.
0