Conditional Formatting based on 2 conditions

  • Thread starter Still learning@work
  • Start date
S

Still learning@work

I am developing a retirement projection. I need to have the row highlighted
if the years of service is greater than 10 (cell D2) and age is greater than
55 (cell F2). How do I use conditional formatting to achieve this?
 
S

Sheeloo

Select the cells you want to highlight in row 2...

Use the formula
=AND($D2>10,$F2>55)

$ in front of the reference will force Excel to evaluate the same formula
for all cells in the row...

You can even paint it down for other rows... 2 will change to the row number
is is painted on...
 
F

FSt1

hi
high light the row you want to change. i recomend that you just high light
the data and not the entire row.

formula is.....=IF(AND($D$2>10,$F$2>55),1,0)

regards
FSt1
 

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