More Conditional Formatting
 

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

More Conditional Formatting
 

Select row 8 and try this CF formula:
=OR(AND($A8="No",$W80,$Y80),AND($B8="No",$W80,$ X80))
Regards,
Stefi

€žtvh€� ezt Ã*rta:

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