Highlighting rows by date critria
Hi I have an excel spreadsheet (issues tracking log), that contains a column for 'Due Date' and a 'Date Closed' column. I would like to color code the rows to differntiate rows that contain issues that are closed, past due, and coming due, as below:
1. Closed, rows that have a value for 'Date Closed", I want to highlight (color-fill) grey ( grey out).
2, Past Due, rows that do not have a value for "date Closed" and for which the Due Date is in the past, I want to highlight red.
3, Coming Due, Rows whos target date is today or next 3 days, I want to highlight yellow.
I want to highlight the entire row, not just the cell according to the above criteria. Any suggestions?
Yep. See this link on How to use Conditional FormattingAny suggestions?
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
Hi, thanks for the refrence to conditional formatting help file. I was able to get #1 to work using conditional formatting and specifying that non-blanks be grey.
However for #2, how to specify a colr code based on 2 cells ( i.e. date completed is blank AND date due is less than today's date ). Should I use a formula? If so how would it look?
Let''s say Date Closed is in A1 and Due date is in A2. After selecting your conditional formatting range, Conditional formatting>New Rule>Use a formula.....Past Due, rows that do not have a value for "date Closed" and for which the Due Date is in the past, I want to highlight red.
TryDoes that work for you? How you would anchor your cells (the $'s) depends on your spreadsheet setup and what ranges you are conditionally formatting.=AND(ISNUMBER($A$1),$A$2<TODAY())
ChemistB
My 2¢
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks