Hi i have a spreadsheet with some dates on it.
I will try to explain it a bit so please bear with me.
I have dates in columns F and G. i have conditional formatting set in column F that colours those cells Red if they were more than 3 days ago.
for that i am using the Rule: Format only cells with, cell value, less than, =NOW()-3 and to fill red in this case.
I then have another condition that overides the first if there is something written in the corresponding cell for Column G. Here i use the rule: Format values where this formula is true, =ISBLANK(G1)=FALSE and ticked stop if true.
so to be clear up to this point. there are dates in column F. The cells in column F will be red if the date in them is more than 3 days ago. Unless there is something (a date) written in column G.
The dates in column G also have conditional formatting. They will turn Red if the date in column F is more than 3 days ago. They will turn green if the date in column F is 3 days or less ago.
Now this works well however i would like weekends and holidays to be left out of the calculation of the days between the dates in column F and G.
Can you please help?
I will try to explain it a bit so please bear with me.
I have dates in columns F and G. i have conditional formatting set in column F that colours those cells Red if they were more than 3 days ago.
for that i am using the Rule: Format only cells with, cell value, less than, =NOW()-3 and to fill red in this case.
I then have another condition that overides the first if there is something written in the corresponding cell for Column G. Here i use the rule: Format values where this formula is true, =ISBLANK(G1)=FALSE and ticked stop if true.
so to be clear up to this point. there are dates in column F. The cells in column F will be red if the date in them is more than 3 days ago. Unless there is something (a date) written in column G.
The dates in column G also have conditional formatting. They will turn Red if the date in column F is more than 3 days ago. They will turn green if the date in column F is 3 days or less ago.
Now this works well however i would like weekends and holidays to be left out of the calculation of the days between the dates in column F and G.
Can you please help?