# Conditional format date and time

#### kelly1

##### Well-known Member
Can someone help me with a conditional format please?
I realise it may need to be done with 2 conditions

If column D = “H” then column F needs to be column E + 24 hrs

If column D = “L” then column F needs to be column E + 5 days

Thanks for any help

Kelly
KAT 02.xls
CDEFG
2
3L27/12/04-15:20
4H15/01/05-14:25
5L16/01/05-12:20
6
Sheet1

### Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

#### Brian from Maui

##### MrExcel MVP
Can you explain further what's suppose to happen if H or L as far as conditioanl formatting? Greater than, less than, equal????

#### kelly1

##### Well-known Member
L= Low Priority
H=High Priory

After the time lapse the colour changes and stays changed

So
if H, colour change after 24 hours
If L, colour change after 5 days

and stay changed

Kelly

#### Brian from Maui

##### MrExcel MVP
kelly1 said:
L= Low Priority
H=High Priory

After the time lapse the colour changes and stays changed

So
if H, colour change after 24 hours
If L, colour change after 5 days

and stay changed

Kelly

Kelly,

Apologies in advance for more questions, but are the date/time in column E true date/time values? And when you say 24 hour change, is it from today minus the date/time in column E?

Replies
13
Views
713
Replies
6
Views
406
Replies
5
Views
389
Replies
6
Views
710
Replies
5
Views
2K

1,181,822
Messages
5,932,265
Members
436,830
Latest member
Sochen

### 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.

### Which adblocker are you using?

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

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