Conditional Formating between 2 set values

Pixelhouse

New Member
Joined
Feb 11, 2021
Messages
1
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
Hi i would like to conditional format one cell according to its value with no other cells to compare it to.
For example:
A1 = 5
I would like to conditional format it so that 5 is green but 0 and 10 are red, and everything in between changes accordingly. So if i change the 5 to 6 or 4 it would turn slightly orange.
Is this possible?

Thanks in advance.
 

Some videos you may like

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

maabadi

Well-known Member
Joined
Oct 22, 2012
Messages
1,616
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
Welcome to MrExcel Message Board.
Select all cells. Go to Conditional formatting, Select Color Scales, More Rules.
Change Format Style to 3-Color Styles. And Select Colors for lowest & mid & Highest Values.
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
48,400
Office Version
  1. 365
Platform
  1. Windows
Welcome to the MrExcel board!
i would like to conditional format one cell according to its value with no other cells to compare it to.

I think maabadi has made a suggestion for a range of cells. If you just have a single cell the select it then

Conditional Formatting -> Color Scales -> More Rules .. -> then set it up like this

1613131956877.png
 

Watch MrExcel Video

Forum statistics

Threads
1,127,423
Messages
5,624,706
Members
416,042
Latest member
Oden

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