how to use custom conditional formatting?

[siamandm]

Hello All,
if i have a cell contains a function like

Code: Select all

=IFERROR(DATEDIF(TODAY(),F5,"M")&" month(s) and "&DATEDIF(TODAY(),F5,"md")&" day(s)","Expired")

and I want to highlight the cell if the result of the cell is 3 months and less

Screenshot 2020-11-06 135352.jpg

[HansV]

Let's say the formulas are in G5:G100.

1) Select this range. I will assume that G5 is the active cell in the selection.
2) On the Home tab of the ribbon, select Conditional Formatting > New Rule...
3) Select 'Use a formula to determine which cells to format'.
4) Enter the formula

=$F5<=EDATE(TODAY(),3)

5) Click Format...
6) Activate the Fill tab.
7) Select a color.
8) Click OK, then click OK again.

[siamandm]

thanks a lot for the reply,
where is my mistake, please?

Screenshot 2020-11-06 144414.jpg

[HansV]

If your selection starts in O4, the formula should be

=$F4<=EDATE(TODAY(),3)

Please note that it refers to F4, not to O4!

[siamandm]

Thanks a lot