Conditional Formatting with a formula at Excel doesn't work

Question

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

Answer 1

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