Conditional formatting dependent on 3 cells

A

abulawski

I want to highlight a line only if it meets 3 criteria from differen
cells. For example A2=Y, B2 or D2=Y, C2=Y. If three equal Y, the
highlight the row. What's the proper way to format this?

Also, is there a quick way to apply the same formula for conditiona
formatting for every row?

Thanks for any and all help
 
D

Debra Dalgleish

1. Select the cells that you want to format (e.g. A2:D50)
2. Choose Format>Conditional Formatting
3. From the first dropdown, choose Formula Is
4. In the formula box, type a formula that refers to the active row:
=COUNTIF($A2:$D2,"Y")>=3
5. Click the Format button, and choose from the formatting options
6. Click OK, click OK
 
Top