Conditional format date and time

kelly1

Well-known Member
Joined
May 11, 2003
Messages
525
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

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
Can you explain further what's suppose to happen if H or L as far as conditioanl formatting? Greater than, less than, equal????
 
Upvote 0
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
 
Upvote 0
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?
 
Upvote 0

Forum statistics

Threads
1,213,543
Messages
6,114,243
Members
448,555
Latest member
RobertJones1986

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
Back
Top