Pixelhouse
New Member
- Joined
- Feb 11, 2021
- Messages
- 1
- Office Version
- 365
- 2019
- Platform
- 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.
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.