Colour format based on cell value question

M Welsh

New Member
Joined
Mar 7, 2015
Messages
20
Hi

I've been trying for a couple of hours to conditional colour format cells based on cell value but can't get it right. I have the formulas but I only seem to be able to enter 1 formula but I need to enter 3?

My rules are:

If B7=>99 but less than 99.9 then shade amber
If B7<99 then shade red
If B7=100 then shade green

Any help is much appreciated in how I can enter 3 different formulas :)

Michael
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
Re: Colour format bsed on call value question

Select the range to highlight (presumably just B7 in this case)

Conditional Formatting
New Rule
Use a formula to determine...

3 colours = 3 formulas

=AND(B7>=99,B7<99.9)
format as amber

=AND(B7>=0,B7<99)
format as red

=B7=100
format as green

QUESTION: Are you sure you meant B7=100 ? Not greater than or equal 100 ?
 
Last edited:
Upvote 0
Re: Colour format bsed on call value question

Thanks for the quick response SpecialK. Do you know how I enter 3 formulas when in "new rule", "use formula to determine...". I can enter one formula to format 1 colour but can't see a way of doing it to get 3 colours.

Hope that makes sense. I've tried to take screenshot but I'm not able to paste into the forum.
 
Upvote 0
Re: Colour format bsed on call value question

Enter one formula at a time.

New formula (amber)
New fromula (red)
New formula (green)

FYI You cant attach files on this forum.
Should you want to post a spreadsheet at some future stage there are tools on this forum for adding small spreadsheet images

https://www.mrexcel.com/forum/about-board/508133-attachments.html
 
Last edited:
Upvote 0
Re: Colour format bsed on call value question

You are a star Special K - all sorted, just had to do one at a time. Been bugging me for years so much appreciated :)
 
Upvote 0

Forum statistics

Threads
1,213,527
Messages
6,114,140
Members
448,551
Latest member
Sienna de Souza

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
Back
Top