Hi all
Could someone help with a conditional formatting formula please.
I have a worksheet where i would like a row to be highlighted depending on a couple of conditions.
The sheet is K to Y in M is the leave date of the staff member then in Q there is a drop down list containing 3 options Deleted, Proxy for 1 month and Proxy for 3 months
If the option Proxy for 1 month is selected then i would like the row highlighted when the date in M is one month old
If the option Proxy for 3 months is selected the i would like the row highlighted when the date in M is three months old. If deleted is selected then do nothing.
Just cannot get the date thing!
Thank you
Could someone help with a conditional formatting formula please.
I have a worksheet where i would like a row to be highlighted depending on a couple of conditions.
The sheet is K to Y in M is the leave date of the staff member then in Q there is a drop down list containing 3 options Deleted, Proxy for 1 month and Proxy for 3 months
If the option Proxy for 1 month is selected then i would like the row highlighted when the date in M is one month old
If the option Proxy for 3 months is selected the i would like the row highlighted when the date in M is three months old. If deleted is selected then do nothing.
Just cannot get the date thing!
Thank you