View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_5_] Sheeloo[_5_] is offline
external usenet poster
 
Posts: 248
Default Conditional Formatting based on 2 conditions

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

Use the formula
=AND($D210,$F255)

$ 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...

-------------------------------------
Pl. click ''''Yes'''' if this was helpful...

"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?