Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formula to highlight dates (and that entire row)
Hi,
Do you mean things exactly 14, 24 and 36 overdue or do you mean 14-23, 24-36, 36? Let's assume the first, and that the numbers are in column A, you didn't give us any idea what your data looks like, Highlight all the rows of data you want formatted and then To conditionally format your cell(s): In 2003: 1. Select the cells you want to format (column C) 2. Choose Format, Conditional Formatting 3. Choose Formula is from the first drop down 4. In the second box enter the formula: =$A1=14 5. Click the Format button 6. Choose a color on the Patterns tab (or any available option) 7. Click OK one. 8. Click Add 9. For Condition 2, from the first drop down pick Formula is 10. In the second box enter the formula: =$A1=24 11. Click the Format button 12. Choose a color and click OK twice. repeat for the third condition. =$A136 In 2007: 1. Highlight all the cells on the rows you want formatted 2. Choose Home, Conditional Formatting, Manage Rules, New Rule 3. Choose Use a formula to determine which cell to format 4. In the Format values where this formula is true enter the following formula: =$A1=14 5. Click the Format button and choose a format. 6. Click OK twice 7. New Rule 8. Choose Use a formula to determine which cell to format 9. In the Format values where this formula is true enter the following formula: =$A1=24 10. Click the Format button and choose a format. 11. Click OK tree times. repeat for a 3rd condtion -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Conditional Formula Writing (for dates)" wrote: Trying to figure out the formula for conditional formatting to highlight dates (and that entire row) for 14, 24, 36+ days overdue. Each time increment would need it's own formatting. Any help would be appreciated. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formating to highlight dates 30, 60, and 90 days out? | Excel Worksheet Functions | |||
Conditional Format to highlight entire row if a condition is met | Excel Worksheet Functions | |||
Highlight the entire row or particular cell using conditional formatting | New Users to Excel | |||
Formula to highlight an entire row when certain text is present. | Excel Discussion (Misc queries) | |||
Conditional Format to Highlight entire Row? | Excel Worksheet Functions |