View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Conditional Formatting based on 2 conditions

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$210,$F$255),1,0)

regards
FSt1

"Still learning@work" wrote:

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?