Conditional Formatting

[KellyMcG03]

I want to set up my worksheet with conditional formatting. Here is a
example of my sheet (see attachment).

attachment:
http://www.excelforum.com/attachment.php?attachmentid=2699&stc=1


My original format for the worksheet is the text color red, I want t
be able to put the date or comment in column E (Date Rcvd) and make th
entire row black text.

Is there a way to do this??

+-------------------------------------------------------------------
|Filename: Pt Log 2.gif
|Download: http://www.excelforum.com/attachment.php?postid=2699
+-------------------------------------------------------------------

 

[bludovico]

Try doing something like this.

Select the entire row you want to format.

GO to conditional formatting.

Drop down the box so it reads "FORMULA" instead of "CELL VALUE".

Put in =$e*7*<=TODAY()

Select the format you want from text or patterns.

THis will mean that any date entered into column E that is today o
before produces a condtionally formatted result.

Then copy the cell with the conditional format, drag down and "Past
Special ; Formats"