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
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 | |||||||
---|---|---|---|---|---|---|---|
C | D | E | F | G | |||
2 | |||||||
3 | L | 27/12/04-15:20 | |||||
4 | H | 15/01/05-14:25 | |||||
5 | L | 16/01/05-12:20 | |||||
6 | |||||||
Sheet1 |