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



"A Need to Excel" wrote:

What formula are you using?

Are you including "$" in the cell reference?

"markythesk8erboi" wrote:

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,..............

"A Need to Excel" wrote:

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

"markythesk8erboi" wrote:

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).