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 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Aug 8, 2013 at 10:18 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Aug 8, 2013 at 10:18 AM
Related:
- Conditional formatting using a formula
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel conditional formatting based on date - Guide
- Credit summation formula - Guide
- Number to words in excel formula - Guide
- Formula spreadsheet definition - Guide
7 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Contributor
Last seen
December 27, 2022
555
Aug 6, 2013 at 10:15 AM
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
I think you are confusing rows with columns.
Formula is:
=A1/B1>0,2
Best regards,
Trowa
analystquestion
Posts
4
Registration date
Monday August 5, 2013
Status
Member
Last seen
August 6, 2013
Aug 6, 2013 at 10:32 AM
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.
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
Posts
2921
Registration date
Sunday September 12, 2010
Status
Contributor
Last seen
December 27, 2022
555
Aug 6, 2013 at 10:57 AM
Aug 6, 2013 at 10:57 AM
And I'm confused with the percentages :)
Formula should be:
=A1/B1>1,2
Best regards,
Trowa
Formula should be:
=A1/B1>1,2
Best regards,
Trowa
analystquestion
Posts
4
Registration date
Monday August 5, 2013
Status
Member
Last seen
August 6, 2013
Aug 6, 2013 at 11:52 AM
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.
-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
Posts
2921
Registration date
Sunday September 12, 2010
Status
Contributor
Last seen
December 27, 2022
555
Aug 6, 2013 at 12:02 PM
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?
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
Posts
4
Registration date
Monday August 5, 2013
Status
Member
Last seen
August 6, 2013
Aug 6, 2013 at 01:12 PM
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...?
Thank you. Maybe it's not possible without creating that additional column...?
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Contributor
Last seen
December 27, 2022
555
Aug 8, 2013 at 10:18 AM
Aug 8, 2013 at 10:18 AM
Then you need to select A1 instead of C1 when applying conditional format.
