conditional format in a row

  • Thread starter Thread starter BK
  • Start date Start date
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?
 
.. is there a way to make the entire row red if the condition for Column D
is met?
Click to expand...

Select the entire sheet (with A1 active), then apply the CF for condition 1
as:
Formula is: =$D1="Overdue"
Format as desired, OK out.

The "$" sign to fix it to col D will produce the required effect

---
 
Hip hip hooray!! Thank you so much!!


Max said:
Select the entire sheet (with A1 active), then apply the CF for condition
1 as:
Formula is: =$D1="Overdue"
Format as desired, OK out.

The "$" sign to fix it to col D will produce the required effect
Click to expand...
 
Back
Top