Greetings all:

I am running XP Pro/Excel 2003.

I have a spreadsheet that I created to track my copy count for a copier on a
maintenance agreement so that I know how I am doing and to avoid those
expensive over contracted amount pay per page costs (cool, I know).

In any event, I have a colum that has a conditional format which will shade
the cell red if I am over my current allotment, and shade the cell green if I
am under. Simple enough, however I don't want any shading if the cell is
blank.

I have some fixed data in these cells:

B3 is my contracted copy amount
B7 is my starting copy count
A7 is my starting agreement date

I Have the following columns

A Current Date
B Current Machine Count
C Count to date formula =IF(ISBLANK(B8),"",(B8-$B$7))
D Day of Contract formula=IF(ISBLANK(B8),"",(A8-$A$7))
E Scheduled Count formula =IF(ISBLANK(B8),"",(($B$3/365)*D8))
F Over/Under Column formula=IF(ISBLANK(B8),"",(E8-C8))

It is this column F where I have the conditional format to shade it red or
green depending on if my current count is over or under my scheduled count.
The way it currently is working is that no number will print, but it will
shade the cell green. I assume it might have something to do with the fact
that I am using ISBLANK in the formula, but I really don't want to have to
copy and drag the conditonal format down each time I update the next line of
the worksheet with new data.

The conditonal format I am using is:

If f8 is less than 0 it will shade the cell red
If f8 is greater than 0 it will shade the cell green

I have tried using a third condition of:

If f8 is 0 then no shading, but this will not work. I always get a green
fill.

Anyone have any ideas?

Sorry for the lenght, but I feel more info is better than less!

Mark