| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting based on 2 conditions
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting based on 2 conditions
see your other post
-- Biff Microsoft Excel MVP "Still learning@work" wrote in message ... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting 5 conditions | Excel Discussion (Misc queries) | |||
| Conditional formatting Based on cell A text with conditions in Cell B | Excel Discussion (Misc queries) | |||
| Conditional formatting more than 4 conditions | Excel Discussion (Misc queries) | |||
| conditional formatting with four conditions | Excel Worksheet Functions | |||
| Conditional formatting with more than 3 conditions. | Excel Worksheet Functions | |||
Linear Mode
