Conditional Formatting

[MB11]

Hello - this should be an easy one

Columns A and B have number values. If the value in column B1 is less than A1, I want it to format green. I've got that part figured out with conditional formatting Help, but how do I get results based on a range? When I apply conditional formatting to B1:B100, it only gives me results for A1, but I need results for adjacent cells A1:A100.

Thanks.

 

[VoG]

Select the whole range and apply the CF formula

Excel Workbook
	A	B
1	30	6
2	10	58
3	62	21
4	6	60
5	61	44
6	2	15
7	65	55
8	32	34
9	100	30
10	76	50
Sheet4

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B1	1. / Formula is =B1	Abc