Hi Everyone!
I have a problem and it works for a finite set of the date range within the current year but do not when extended to next year.
I have to apply conditional formatting on cells range(=$H$5:$AE$28) based upon date range in Column F & Column G.
Conditions:
Grey color the cells if the dates(row 4:Column H to AE) are less than the date in Column F
Grey color the cells if the dates (row 4:Column H to AE) are greater than the date in Column F
it works fine when I apply the format for current year 2018. But then I extend to next year, it fails.
Please if any one can help me i would be highly oblized. This is an important project to me.
Thanks
Abhinav
Bookmarks