Conditional formatting dependent on 3 cells

  • Thread starter Thread starter abulawski
  • Start date Start date
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
 
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
 

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

Similar Threads

Conditional Format Question 4
conditional formatting group of cells 2
Conditional Formatting - Formulas 2
copy conditional formatting with 'unique' cell references 1
Conditional Formating 2
Advanced Conditional Formatting Ideas Needed! (ok, maybe not that advanced...) 2
Conditional formatting using OR() & AND() 2
Conditional Formatting 1

Back
Top