cell direction not cell location

[daniels012]

I need a conditional format for a cell to Yellow highlight when the cell 4 spaces to the left of the current cell has the number "86".

How can I write this without using cell address?
Right now I have in cell G116:

=C116=86

Thank You
Michael D

 

[VoG]

Perhaps

=OFFSET(G116,0,-4)=86

 

[HalfAce]

How can I write this without using cell address?

I'm not sure what you mean by this.
How is it to know which cell you want it to look at if we can't tell it the address?

I'm not sure exactly what you're wanting to do.

 

[T. Valko]

I need a conditional format for a cell to Yellow highlight when the cell 4 spaces to the left of the current cell has the number "86".

How can I write this without using cell address?
Right now I have in cell G116:
=C116=86

Thank You
Michael D

Maybe this...

=INDIRECT("rc[-4]",0)=86

 

[daniels012]

Ok,
Is there a way to not use the G116.
I want to copy this formula to other areas so I would like relative refrencing

 

[VoG]

In CF, the G116 should adjust automatically I think but try Biff's suggestion.

 

[daniels012]

I spoke too soon.
T. Valko I love it and it seems to be working!

Thank You,
Michael D

 

[HalfAce]

When I CF a cell to be yellow when the one 4 cells to its left reads 86, I can copy that & paste in another cell and the reference is relative, making the new cell turn yellow too when the one 4 cells to its left says 86.

Isn't that what you're looking to do?

 

[T. Valko]

I spoke too soon.
T. Valko I love it and it seems to be working!

Thank You,
Michael D

You're welcome. Thanks for the feedback!

 

[daniels012]

Half Ace,
I think the problem I was having was it put the "$" in the formula and that was messing me up, but yes it did work once I tried it.
But it was awesome to see Valko's formula as well

Mcihael D