Two part question;number of day fill down fails and how to condition format

[dave wagner]

I'm trying to "fill down" the difference between two dates:

A5 =TODAY()

J5 = A5 - J6 "number of days behind"

When I try to fill down J5 value, I get nothing but errors, what did I do
wrong?
The error is A5 is incremented, where it should be a "fixed" cell and J6
should increment accordingly.

The second part is if the value of days behind is 90 or greated I would like
to change the format for cells k9:m9. Where would I do this? from j col or
the k column?

Thanks ahead for any help.

-dave

 

[Dave Peterson]

Try

=$a$5-j6

Then drag down.

The $ signs tell excel to not adjust that portion of the address when you copy
it. (Either the column or the row (or both).)

 

[dave wagner]

Thanks Dave, that is just what I was looking for. I totally went blank on
remembering the "$" function.

Dave