Forum Discussion
Solved
formula en fechas
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...
You 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.
You 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.
Thanks
