May 14 2020 07:13 PM
Tenga una fecha x en la columna B. Quiero mediante un formato condicional.... no he sabido como... cambiar de color si lleva 1 mes de haberse ingresado, otros si lleva dos meses y por último un color rojo. Es decir que cambie de color cada mes desde que se ingreso el dato
May 14 2020 09:46 PM
SolutionYou want to change the color the date field depending on current date. This can be achieved by using conditional formatting twice. One for highlighting for entries which are 1 month prior to current and second one for highlighting which are 2 months prior (Red).
Have a look at enclosed file. Let me know if i have correctly understood your problem.
May 14 2020 09:46 PM
SolutionYou want to change the color the date field depending on current date. This can be achieved by using conditional formatting twice. One for highlighting for entries which are 1 month prior to current and second one for highlighting which are 2 months prior (Red).
Have a look at enclosed file. Let me know if i have correctly understood your problem.