Conditional Formatting with a formula at Excel doesn't work

I want to color the line by target date.

I made table like this

and set formatting rule as

if date is "2023/02/21", the background at that line should be changed to "pink"…

However, it doesn’t work.

could you help me?

My expectation is changing background color like this

>Solution :

It does work, since "21/2/2023" represents a text and not a number, you need to use something as follows

=$C4="21/2/2023"*1

to get the row highlighted where the target dates is 21/2/2023, make it absolute relative reference as $C4 in your example .

Refer the applies to in screen-prints