I have 5 cells. 2 of the cells are Yes/No (A8:B8). The other 3 contain
dates (W8:Y8). If the two Yes/No cells say 'Yes', then my conditional
formatting formula can stay the way it is, which is
'=COUNTIF($W8:$Y8,"0")=3'. However, if one of the two Yes/No cells says
'No' then I only need two of the three date cells to have a date.

So, if A8="no", then only W8,Y8 need to be "0" for my row to be
highlighted. And, if B8="no", then only W8,X8 need to be "0" for my row to
be highlighted. P.S.-A8 and B8 would never both be "no".

Would I need to add more formatting conditions, or is this just a whole
different type of formula altogether?

Thanks