Conditional Formatting

[Badgerwatch]

Please could somebody help? I am trying to use a simple condition of Great than or equal to. The complex part is that I want each row (217 of them) to check whether they are great or equal to the corresponding row but it wont work.

Thanks in advance for your help

 

[Badgerwatch]

Sorry, let me make that clearer. I want each Row in column B to check against the values in the corresponding column.

 

[philwojo]

Can you post what you currently have now that isn't work, the formula.

 

[jtakw]

Hi,

Book1
	A	B	C	D	E
1		1	1		TRUE
2		2	3
3		3	2
4		4	4
5		5	7
Sheet1

Cell Formulas
Range	Formula
E1	=B1>=C1

Use E1 formula for CF for B1 and use Format Painter to copy CF down Column B.

 

[philwojo]

Well what you have there seems to be working and your example appears to reflect that, what part doesn't appear to be working for you, I am not sure I'm following.

 

[jtakw]

Well what you have there seems to be working and your example appears to reflect that, what part doesn't appear to be working for you, I am not sure I'm following.

Are you replying to my answer in post #4 for OP???

 

[philwojo]

Are you replying to my answer in post #4 for OP???

Crap, yes, sorry about that, I was at work and didn't realize it wasn't from the OP, my mistake.