Tracking Project With Gantt Chart

Hi,

i am trying the below formula for my gantt chart

=IF(AND('Main Data'!B3<>"",'Main Data'!B3<=TODAY(),ISNUMBER('Main Data'!B3)),"BULE",IF(AND('Main Data'!B3<>"",ISTEXT('Main Data'!B3)),"YELLOW"))

Condition 1:
Cell Value, equal to =B3="BLUE"

Condition 2:
Cell Value, equal to =B3="YELLOW"

However, when i applied this to Conditional Formatting it seems does not work.

Could you please advice?