SOLVED

formula en fechas

%3CLINGO-SUB%20id%3D%22lingo-sub-1391442%22%20slang%3D%22es-ES%22%3Eformulated%20in%20dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1391442%22%20slang%3D%22es-ES%22%3E%3CP%3EHave%20an%20x-date%20in%20column%20B.%20I%20want%20to%20do%20a%20conditional%20format....%20I%20haven't%20known%20how...%20change%20color%20if%20it%20takes%201%20month%20of%20being%20entered%2C%20others%20if%20it%20takes%20two%20months%20and%20finally%20a%20red%20color.%20That%20is%20to%20say%20that%20it%20changes%20color%20every%20month%20since%20the%20data%20is%20entered%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1391442%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1391763%22%20slang%3D%22en-US%22%3ERe%3A%20formula%20en%20fechas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1391763%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F668680%22%20target%3D%22_blank%22%3E%40itzhiarayuro%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20want%20to%20change%20the%20color%20the%20date%20field%20depending%20on%20current%20date.%20This%20can%20be%20achieved%20by%20using%20conditional%20formatting%20twice.%20One%20for%20highlighting%20for%20entries%20which%20are%201%20month%20prior%20to%20current%20and%20second%20one%20for%20highlighting%20which%20are%202%20months%20prior%20(Red).%3C%2FP%3E%3CP%3EHave%20a%20look%20at%20enclosed%20file.%20Let%20me%20know%20if%20i%20have%20correctly%20understood%20your%20problem.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1392975%22%20slang%3D%22es-ES%22%3ERe%3A%20formulated%20in%20dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1392975%22%20slang%3D%22es-ES%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F665807%22%20target%3D%22_blank%22%3E%40ShishirKumar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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

2 Replies
Highlighted
Best Response confirmed by itzhiarayuro (New Contributor)
Solution

Hi@itzhiarayuro 

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.

Highlighted

@ShishirKumar 

Thanks