Hi

Id like to conditional format column A to red fill if the date is 5 working days or more.

If blank then ignore or leave as is.

If it can’t be done for working days, then 7 days and over is fine

I could have today’s date  in cell D2, in another sheet called ‘BH’

Thanks

​HiId like to conditional format column A to red fill if the date is 5 working days or more. If blank then ignore or leave as is. If it can’t be done for working days, then 7 days and over is fine I could have today’s date  in cell D2, in another sheet called ‘BH’ Thanks  Read More

​