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

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

Brian from Maui

MrExcel MVP
Joined
Feb 16, 2002
Messages
8,459
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
Joined
May 11, 2003
Messages
525
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
Joined
Feb 16, 2002
Messages
8,459
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?
 

Forum statistics

Threads
1,147,847
Messages
5,743,522
Members
423,801
Latest member
paulj4177

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