Conditional Formatting using date criteria

[mecerrato]

I have this formula as a conditional format that highlights certain cells that meet the date requirements. I just want to add an extra criteria that highlights as well if the date=today. Seems simple but I cannot get the syntax right.

can anyone help?

=AND(ISNUMBER(SEARCH("Condo",K11)),OR(AND(WEEKDAY(TODAY())>= 3,WEEKDAY(TODAY())<=6,INT(X11)=INT(TODAY()-1)),AND(WEEKDAY(TODAY())=2,INT(X11)>=INT(TODAY()-3),INT(X11)<=INT(TODAY()-1))))

 

[Joe4]

Maybe:

=OR(X11=TODAY(),AND(ISNUMBER(SEARCH("Condo",K11)),OR(AND(WEEKDAY(TODAY())>= 3,WEEKDAY(TODAY())<=6,INT(X11)=INT(TODAY()-1)),AND(WEEKDAY(TODAY())=2,INT(X11)>=INT(TODAY()-3),INT(X11)<=INT(TODAY()-1)))))