Why isn't this LESS THAN ZERO conditional format working??

Marq

Well-known Member
Joined
Dec 13, 2004
Messages
914
Office Version
  1. 365
  2. 2007
Platform
  1. Windows
I have a work book I am trying to make a certain range of cells read if any value of a particular cell is less than 0 then make it red and bold.

My range is G3 through G4...each cell has a simple formula in it...which is the difference between estimated hours and actual hours. I want the cell to turn red and bold when the remaining hours get into negative category.

For example the formula in G4 is D4-O4 (estimated hours minus actual hours)....Im trying to make the simple condition of red and bold if G4 is negative.

I am highlighting G4 through G25
Then going to conditional formatting/new rule/use a formula to determine which cells to format

under "Format values where this formula is true: I am putting in <0

then setting my format to red and bold.

I plug in a negative number in G4 to test it and it doesn't work..no red.no bold.

I did a similar conditional format for a different range of cells on the same worksheet...Q4 through Q25....which the condition is if a cell value in the range is greater than 100% then make that particular cells value red and bold and that condition works perfect using the same steps I mentioned above.

So what am i doing wrong with the G4 through G21 condition?
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
56,406
Office Version
  1. 365
Platform
  1. Windows
The formula needs to be
=G4<0
 

Ormie

New Member
Joined
Oct 26, 2019
Messages
20
Office Version
  1. 2013
Platform
  1. Windows
1580229030712.png


Use this for your conditional formatting instead
 

Marq

Well-known Member
Joined
Dec 13, 2004
Messages
914
Office Version
  1. 365
  2. 2007
Platform
  1. Windows
View attachment 5081

Use this for your conditional formatting instead


ok..thats working...and thank you and thanks to everyone...but why would my other condition work with the greater than 100% work and this less than zero condition didnt, even though i followed the same steps???
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
56,406
Office Version
  1. 365
Platform
  1. Windows

Watch MrExcel Video

Forum statistics

Threads
1,129,285
Messages
5,635,314
Members
416,852
Latest member
kanaikls

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