Format a cell based on two conditions

[John1953]

I need to format a range of cells based on two conditions. One condition is if the date in the cell is less than or equal to TODAY(), format font bold/red (I can do this using conditional formatting), but if an adjacent cell has "Retired" in it, forget the bold/red and strikethrough the date in the cell instead.

 

[bebo021999]

You need 2 CF formula, in order:
=B1="Retired"
Stop if trues
format font: "Regular", color: automatic; Strikethrough

and

=B1<=TODAY()
format font: "Bolf", color: pick red color