Hi there
I hope you can help with query below / attached file.
Using ‘Conditional Formatting’ on column ‘F’ (Time in Service) how can I highlight cells that are greater than or equal to ‘3 months’?
Thanks
Hi there
I hope you can help with query below / attached file.
Using ‘Conditional Formatting’ on column ‘F’ (Time in Service) how can I highlight cells that are greater than or equal to ‘3 months’?
Thanks
Please try CF formula
=DATEDIF($E2,TODAY(),"m")*($D2="open")>=3
applies to F2:F11
Excellent! thank you Bo_Ry.
Hi Bo
Any chance i can modify the above formula not to highlight blank cells i.e. if col F 'Date started with service' is blank?
Thanks
Yes,
=(DATEDIF($E2,TODAY(),"m")*($D2="open")>=3)*($F2<>"")
Great stuff! Thank you Bo_Ry.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks