More Conditional Formatting

T

tvh

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
 
S

Stefi

Select row 8 and try this CF formula:
=OR(AND($A8="No",$W8>0,$Y8>0),AND($B8="No",$W8>0,$X8>0))
Regards,
Stefi

„tvh†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top