Forum Discussion
Weekend Overtime Tracker Conditional Formatting
Hi All, I would want to know how I may be able to use the 'conditional formatting' function for my requirement in the attached picture here. The condition is that every third Friday sh...
Hi Afthab,
That could be conditional formatting rule with formula
=IFERROR(OFFSET(C4,0,-7)*OFFSET(C4,0,-14)*(C$2="F"),0)
applied to your entire range starting from C4
Fantastic! it worked.
Thanks a million!!!!
You are welcome