How do I copy a format that.........

[Guest]

I have a format set for cell (b2). this format analyzes the value of cell
(a2). If the value of (a2)and(b2)are equal then the text shows in green. If
not, the text shows in red. Ok....YAY.... Now how do I go about formating an
entire column(b) to do this with column(a)? Sounds stupid but everytime I try
using the format painter then (b3) for example still analyzes (a2) rather
then analyzing (a3).

 

[Guest]

Just out of curiosity, have you tried using conditional formatting?

 

[Guest]

Yes I have. Same problem. It only analyzes the first cell. What I want it to
do is analyze the cell directly to the left of it wherever it is. So I
understand how to get it to do this with (b2) analyzing (A2). but then B3,
b4, b5,..... ALL analyze (a2) rather then analyzing A3, a4, a5,..............

 

[Guest]

What formula are you using?

Are you including "$" in the cell reference?

 

[Guest]

cell value, is equal to =$G$2
cell value, is not equal to =$G$2

 

[Pete_UK]

If you want to apply the format downwards, don't use $2 - just put 2.
If you want to apply the CF across the sheet on adjacent columns,
don't use $G.

In your first post you talked about columns A and B, so this is a bit
confused.

Hope this helps.

Pete

 

[Guest]

Yeah, that's it -- The $ tells it to keep looking in the same spot. Try it
without it, and see what happens.