Conditional formatting

[dbonser]

I have a spreadsheet that has 13 columns. The first column has a value in it. I want the conditioning formatting to paint the cell green if the value in the columns 2-13 is greater than or equal to that value in the first column and paint it red if it is less than the value in the first column. In my conditional formatting for the value to compare it to I do something like =b2 so that if I change that value it would recompare to the other columns. I understand that if it hits the first one and the value is true it will stop, but my problem is that some of the columns do not have values in them yet - they are null. For some of them it paints it red and for others it paints it green, I compared the rules and they look the same. From reading others in the forum it appeared there had to be values in those cells before you could apply conditional formatting. Is that true? If so, that doesn't help because I could manually paint those cells if I want to do one cell at a time, it would defeat the purpose of conditional formatting.

 

[Fluff]

Hi & welcome to MrExcel.
What should happen if cols 2-13 have values both greater & smaller than col A?

 

[dbonser]

Hi & welcome to MrExcel.
What should happen if cols 2-13 have values both greater & smaller than col A?

If cols 2-13 < col 1 = cell should be red; if cols 2-13 => col 1 = cells should be green

 

[Fluff]

Yes, but what if there are values both greater than & smaller than col A?

 

[dbonser]

Yes, but what if there are values both greater than & smaller than col A?

You only have one value in each cell. If col A row 1 is 500 and on the same row, col b is 25 and col c is 1000, then the cell for b should be red and the cell for c should be green

 

[Fluff]

Ok, that makes sense, I thought you were trying to highlight col A.
For green you can use

=B2>=$A2