Date Range Conditional format outside the Cells without data

seoabhinav83

New member
Joined
Jun 11, 2018
Messages
2
Reaction score
0
Points
0
Excel Version(s)
2016
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 anyone can help me I would be highly obliged.
Thanks
Abhinav
 

Attachments

  • Copy of Accounts_Quick_StatusView (003).xlsm
    19.2 KB · Views: 5
Apologize. I will be careful next time. Thank you p45cal!
 
Back
Top