copperwasher
Board Regular
- Joined
- Mar 1, 2016
- Messages
- 84
- Office Version
- 365
- Platform
- Windows
Hi there Excel Experts,
I am using conditional formatting as a basic setting - as below
if...
number = 1 = yellow
number < 1 = red
number > 1 = green
Sounds simple enough!
So what am I missing here... As this is the output!
How can the red be shown when the number is 1.00
Red has been set when the number is less than 1.00
The cell is formatted to number - checked
I am always braced for the obvious answer
And willing to learn
My thanks and appreciation
Copperwasher
I am using conditional formatting as a basic setting - as below
if...
number = 1 = yellow
number < 1 = red
number > 1 = green
Sounds simple enough!
So what am I missing here... As this is the output!
How can the red be shown when the number is 1.00
Red has been set when the number is less than 1.00
The cell is formatted to number - checked
I am always braced for the obvious answer
And willing to learn
My thanks and appreciation
Copperwasher