Another Conditional Formatting Question

**MEL79** · 03-12-2005, 11:47 AM

I have everything working in regards to the format changing colours when it's suppose to and the date counting column stopping when I put in a received date.

Now I need the formatting to change when I actually do put in a date received in the g column.

I explain what I have going on in the spreadsheet (already mentioned it in a previous thread)

D Column - Start Date
E Column - End Date
F Column - # Days til recontact
G Column - Date Received

when F is between 0 and 30 the row is blue, any other time it's red. I would like it to change to black when I enter the received date.

pinmaster · 03-12-2005, 03:02 PM

Hi
condition1:
formual is
=$G$1>0

make sure it is in the first condition (condition1).

HTH
JG

**MEL79** · 03-12-2005, 05:12 PM

I tried this but I not quite getting it. It works if the rows that are overdue but not the ones that have time left.

pinmaster · 03-12-2005, 05:53 PM

Hi

Did you put it as your first condition "condition 1"? This is very important!

Condtitional Formatting Setup:

condition 1: turn row black when G1 > 0
condition 2: turn row blue when F1 is between 1 and 30

JG