Conditional formatting and "autoselecting" cells

[Bowbender]

Here is the deal. I have two columns which get data appended to the
daily (at the bottom). Let's say column A and B. Column A is the dat
the item ships out. Column B is for when the item was returned.

Here is how the conditions are set up.

Condition 1

[Cell Value Is] [greater then] [=$B$1]
No Format Set

Condition 2

[Cell Value Is] [less than] [=TODAY()+30]
Format text red

(Bracket used for clarification only)

This setup works fine, but I would like to replace =$B$1 with somethin
that would automatically "look" one cell the right for the value. The
I wouldn't have to go to each cell, do conditional formatting an
change the B value for each one.

The xls worksheet is already 40 pages long so what I am try to do i
highlight all the cells I would like in the A column and apply th
conditional formatting.

Hope I haven't lost anyone. Thanks for any help

 

[Frank Kabel]

Hi
for the fist condition try
[Cell Value Is] [greater then] [=$B1]

 

[Bowbender]

I gave that a try and it seems to work the same as =$B$1. I am als
trying to use the Offset function but I want to reference value to b
the one that the Conditional formatting is on.

=Offset("Current Cell",0,1) <--Something like this which would replac
=$B$1

Thanks for the help though.

Hi
for the fist condition try
[Cell Value Is] [greater then] [=$B1]

 

[Bowbender]

If you set up your first cell and us the Autofill (where you left clic
and hold on the bottom right corner of the cell and drag down it wil
automatically increase the number in the =$B$1 to =$B$2 and so on.
Sometimes it's the things that are right in front of you.:rolleyes