Conditional formatting for elapsed time

[Eqwizzle]

I am wanting a formula that will color code the cells depending on the value which is elapsed time. I would like for the cell to turn red if past 24hrs, orange if past 10hrs, yellow if past 5hrs, and blue if past 1hr. I tried the formula =H2 > Time(24,0,0), H2 <> “”. But that formula isn’t functioning how I would like.

New to excel and I am a novice just learning from various online tutorials.

 

[bebo021999]

Red:

=H2>1

Orange

=H2>10/24

Yellow

=H2>5/24

Blue

=H2>1/24

Drag and drop to arrange the rules in the following order:

1. Red Rule
2. Orange Rule
3. Yellow Rule
4. Green Rule

Note on "Stop If True"​

For each rule, check the Stop If True box
Explanation:
Rule order is very important because Excel will evaluate the rules from top to bottom. If a rule is met, Excel will not evaluate the rules below (if "Stop If True" is checked).
This means that if cell H2 is greater than 1, the cell will be colored Red and the other rules will not be evaluated.

 

[Eqwizzle]

Red:

=H2>1

Orange

=H2>10/24

Yellow

=H2>5/24

Blue

=H2>1/24

Drag and drop to arrange the rules in the following order:

1. Red Rule
2. Orange Rule
3. Yellow Rule
4. Green Rule

Note on "Stop If True"​

For each rule, check the Stop If True box
Explanation:
Rule order is very important because Excel will evaluate the rules from top to bottom. If a rule is met, Excel will not evaluate the rules below (if "Stop If True" is checked).
This means that if cell H2 is greater than 1, the cell will be colored Red and the other rules will not be evaluated.

I followed the instructions and it turned my entire column red. I would like for the rules to only apply if there is a value within the cell. I also left stop if true unchecked for each rule.

 

[bebo021999]

I followed the instructions and it turned my entire column red. I would like for the rules to only apply if there is a value within the cell. I also left stop if true unchecked for each rule.

Hmm, may be cell contains textstring that always >0
Try:
=H2-1>0

Or
Your date are not real date-time, but date-time_stores_as string
???

Could you share file via gg drive, or an image at least?

 

[Eqwizzle]

Hmm, may be cell contains textstring that always >0
Try:
=H2-1>0

Or
Your date are not real date-time, but date-time_stores_as string
???

Could you share file via gg drive, or an image at least?

 

[Joe4]

If you are sharing images, please don't take pictures with your phone/camera and share those. Those are extremely difficult to read.
Take a screen shot with the Snipping Tool or some other program like that, and share that instead.

 

[Eqwizzle]

If you are sharing images, please don't take pictures with your phone/camera and share those. Those are extremely difficult to read.
Take a screen shot with the Snipping Tool or some other program like that, and share that instead.

Will do. Thanks I forgot about the snipping tool.

 

[Eqwizzle]

I have now added an updated image using Windows snipping tool. Please provide any help and if you need more than one image, please let me know. Thanks.

 

[bebo021999]

Is your worksheet currently in formula displaying mode?
Please adjust it so that we can see the results as well as the cell colors

 

[Eqwizzle]

Is your worksheet currently in formula displaying mode?
Please adjust it so that we can see the results as well as the cell colors

Yes, my formulas were displayed. I have updated this post with several images. I adjusted the date and time to illustrate the issue. The cell should not be in the color of red but blue because it is a duration of equal to greater than an hour.