SOLVED

How to tell if less then 30 days since visit

%3CLINGO-SUB%20id%3D%22lingo-sub-3434501%22%20slang%3D%22en-US%22%3EHow%20to%20tell%20if%20less%20then%2030%20days%20since%20visit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3434501%22%20slang%3D%22en-US%22%3E%3CP%3EHey!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20needing%20to%20format%20this%20spreadsheet%20to%20see%20if%20the%20date%20of%20callback%20is%20less%20then%2030%20days%20from%20install%2C%20on%20the%20entire%20spreadsheet.%20HELP%20PLEASE%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22165%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2279.3594px%22%20height%3D%2279px%22%3EInstall%20Date-%3CU%3ECELL%20D%3C%2FU%3E%3C%2FTD%3E%3CTD%20width%3D%2284.6406px%22%20height%3D%2279px%22%3E%3CP%3ECallback%20Date-%3C%2FP%3E%3CP%3E%3CU%3ECELL%20E%3C%2FU%3E%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3434501%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3434592%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20tell%20if%20less%20then%2030%20days%20since%20visit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3434592%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1403376%22%20target%3D%22_blank%22%3E%40KKEILMAN%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWould%20you%20like%20to%20highlight%20those%20cells%3F%20If%20so%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESelect%20D2%3AE100%20(or%20as%20far%20down%20as%20the%20data%20go).%3C%2FP%3E%0A%3CP%3EThe%20active%20cell%20in%20the%20selection%20should%20be%20in%20row%202%2C%20i.e.%20D2%20or%20E2.%3C%2FP%3E%0A%3CP%3EOn%20the%20Home%20tab%20of%20the%20ribbon%2C%20click%20Conditional%20Formatting%20%26gt%3B%20New%20Rule...%3C%2FP%3E%0A%3CP%3ESelect%20'Use%20a%20formula%20to%20determine%20which%20cells%20to%20format'.%3C%2FP%3E%0A%3CP%3EEnter%20the%20formula%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DAND(%24E2%26lt%3B%26gt%3B%22%22%2C%24E2%26lt%3B%24D2%2B30)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EClick%20Format...%3C%2FP%3E%0A%3CP%3EActivate%20the%20Fill%20tab.%3C%2FP%3E%0A%3CP%3ESelect%20a%20color.%3C%2FP%3E%0A%3CP%3EClick%20OK%2C%20then%20click%20OK%20again.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hey!

 

I am needing to format this spreadsheet to see if the date of callback is less then 30 days from install, on the entire spreadsheet. HELP PLEASE

 

Install Date-CELL D

Callback Date-

CELL E

1 Reply
best response confirmed by KKEILMAN (Occasional Visitor)
Solution

@KKEILMAN 

Would you like to highlight those cells? If so:

 

Select D2:E100 (or as far down as the data go).

The active cell in the selection should be in row 2, i.e. D2 or E2.

On the Home tab of the ribbon, click Conditional Formatting > New Rule...

Select 'Use a formula to determine which cells to format'.

Enter the formula

 

=AND($E2<>"",$E2<$D2+30)

 

Click Format...

Activate the Fill tab.

Select a color.

Click OK, then click OK again.