Hi gurus,
I wonder if anyone please guide me - i have set the conditional formatting using below formula to turn red after 179 days - however I would like to have a 6 calendar months instead of days :
=A8+179<=A9
Please can someone help me how to have conditional formatting to turn red after 6 months instead of 179 days.
thank you
I wonder if anyone please guide me - i have set the conditional formatting using below formula to turn red after 179 days - however I would like to have a 6 calendar months instead of days :
=A8+179<=A9
Please can someone help me how to have conditional formatting to turn red after 6 months instead of 179 days.
thank you