Input Date calculate in Condition format

Dear Sir,
I would like to put the color in pivot table with condition format for which date which more than 90 day from today such as if use 30/07/2021- in date column in excel and more than 90 day and then put the color. Please kindly suggest how to put the formula.

thanks.

Hi,Sir
this is work ka but will show color for another cell to contain text and blank cell as well. Can use any formula to solve this?
and also show earlier than 01/05/2021 and show color? can I use any formula?
thanks.

Hi,Sir
when i use your formular with isnumber, it 's not show color at all.
pls suggest.
thanks.

First formula:=AND(B3 <> "",--B3 < (TODAY()-90),--B3 >= DATE(2021,5,1))
Second formula: =AND(B3 <> "",--B3 < DATE(2021,5,1))

Hi, Josephteh
This fomular still not work.The color still show incorrect place.
please suggest more?
thanks.

First formula "more than 90 days from today" should be: =AND(B3 <> "",--B3 > (TODAY()+90))

Dear Joseph
Still not correct to show. Please see attach file for Result table, I need to highlight only date
which less than 01 May 2021 in case that company have several date and then to detect last date of that company
if last date show less than 01 May 2021 and then show color.
if in case that company have only one date and less than 01 May 2021 and to show color as well.
a bit changing.
Please kindly help?
thanks a lot for support ka.

Conditional formatting formula: =AND(B3 <> "",--B3=AGGREGATE(14,3,$B$3:$B$21/($A$3:$A$21=A3),1),--B3 < DATE(2021,5,1))

I have to turn on "Repeat item labels" for the "NAME" field > right-click cell A2 > Field Settings > Layout & Print > tick "Repeat item labels" > OK.

You can hide the repeat labels by doing conditional formatting.

Hi
still not work in my original file.