Display Number Color Based on Value

meppwc

Well-known Member
Joined
May 16, 2003
Messages
559
Office Version
  1. 365
Platform
  1. Windows
I have a column of numbers that I am trying to get to display based on the value. (The field is formatted as percentage and must stay that way).

I want any number that is < 90% to appear red, but any number => 90% to appear black.

Can someone assist me?
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Kenneth Hobson

Well-known Member
Joined
Feb 6, 2007
Messages
3,181
Office Version
  1. 365
Platform
  1. Windows
Use a Conditional Formatting or a Custom Number format. The former is easily done. Say in C2, select the Home menu and then Conditional Formatting. Set a new rule using the formula: =C2<90 or =C2<0.90 as needed. Set the font or fill color for that condition as needed. Apply condition to as many cells as needed.
 
Upvote 0

meppwc

Well-known Member
Joined
May 16, 2003
Messages
559
Office Version
  1. 365
Platform
  1. Windows
Kenneth
It is not working
cell C2 contain the value of 100%
When I apply the conditional Formatting rule using =C2<90 and then set the color to red
The end result is the cell turns red...............that should only happen if the percentage value in C2 is less than 90%
I also tried =C2<0.90 and got the same unwanted results.
Am I doing something incorrect?
 
Upvote 0

Kenneth Hobson

Well-known Member
Joined
Feb 6, 2007
Messages
3,181
Office Version
  1. 365
Platform
  1. Windows
I most always test code before posting solutions so yes, you have something wrong. I was hoping that the latest update of the forum software would have allowed attachments. That makes it easier to see the problem and the solution.

Format the cell A1 as percentage. Choose ribbon/menu items and set formula by:
Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format > Format values where this formula is true: =A1<0.90 > Format... > Fill > red color > Ok > OK.
 
Upvote 0

meppwc

Well-known Member
Joined
May 16, 2003
Messages
559
Office Version
  1. 365
Platform
  1. Windows
Kenneth
That worked great. Thank you so much for the assistance.
 
Upvote 0

Forum statistics

Threads
1,195,856
Messages
6,011,976
Members
441,661
Latest member
Pammie007

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top