May 15 2021 11:41 PM
Hello Everyone,
I would like to know how to have a cell change colour as it approaches an expiry date, for example, the expiry date is 23-Sep-21..from the 23-Jul-21 the cell is green...23-Jul-21 to 23-Aug-21 it becomes yellow and then from the 23-Aug-21 to the expiry date of the 23-Sep-21 the cells turns red. so, as the date changes the cell colour changes with it.
Can you please explain with example that what formula should i write in Conditional Formatting?
May 16 2021 12:08 AM
SolutionMay 16 2021 12:29 AM
May 16 2021 12:08 AM
Solution