B
BK
Using Excel 2003
I have the current date displaying in A1.
My rows of data include "request date" in Column A, "person requesting work"
in Column B, "work requested" in Column C, and "date completed" in Column D.
I've written an IF statement in Column D that will display "overdue" if the
request has not been completed within seven days.
Then I selected Column D and applied a conditional format: If the cell is
equal to "overdue" color the cell red.
Now here is my question, is there a way to make the entire row red if the
condition for Column D is met?
I have the current date displaying in A1.
My rows of data include "request date" in Column A, "person requesting work"
in Column B, "work requested" in Column C, and "date completed" in Column D.
I've written an IF statement in Column D that will display "overdue" if the
request has not been completed within seven days.
Then I selected Column D and applied a conditional format: If the cell is
equal to "overdue" color the cell red.
Now here is my question, is there a way to make the entire row red if the
condition for Column D is met?