Hi,
Looking for help in conditional formatting.
I have data in B2:H50.
C2 Has a date when an event occurred and D2 has a date which increases by a day everyday with respect to C2.
Till the time the difference in dates for C2 and is D2 is less than or equal to 7, I want to highlight the whole row B2 to H2 "Red"
On the 8th day the row C2 to H2 should be back to "No Fill"
Thanks,
Vij
Looking for help in conditional formatting.
I have data in B2:H50.
C2 Has a date when an event occurred and D2 has a date which increases by a day everyday with respect to C2.
Till the time the difference in dates for C2 and is D2 is less than or equal to 7, I want to highlight the whole row B2 to H2 "Red"
On the 8th day the row C2 to H2 should be back to "No Fill"
Thanks,
Vij