Hello. I hope someone is able to help me. This seems simple (and I'm sure it is), but I cannot work it out.
I have 2 columns of figures (A and B). I want to highlight in red the cell (A2) in column A, if "B2 divided by A2 is less than 1.1 or greater than 2". So in the example below, A2 and A5 would be highlighted in red.
[TABLE="width: 150"]
<tbody>[TR]
[TD="align: center"]A
[/TD]
[TD="align: center"]B
[/TD]
[TD]B/A=
[/TD]
[/TR]
[TR]
[TD]101
[/TD]
[TD]213.59
[/TD]
[TD]2.11
[/TD]
[/TR]
[TR]
[TD]334
[/TD]
[TD]458.23
[/TD]
[TD]1.37
[/TD]
[/TR]
[TR]
[TD]266
[/TD]
[TD]430.86
[/TD]
[TD]1.62
[/TD]
[/TR]
[TR]
[TD]847
[/TD]
[TD]517.6
[/TD]
[TD]0.61
[/TD]
[/TR]
</tbody>[/TABLE]
I've tried creating a conditional formatting for column A, like =IF(B2/A2<1.1) or =IF(B2/A2>2), but it doesn't work and I need to include them together like =IF(B2/A2<1.1,IF(B2/A2>2)) and also affect the entire column, not just Row 2 (using/ not using "$" perhaps?).Can some one help me please. I'm clearly missing something or writing the formula wrong.
Thanks.
I have 2 columns of figures (A and B). I want to highlight in red the cell (A2) in column A, if "B2 divided by A2 is less than 1.1 or greater than 2". So in the example below, A2 and A5 would be highlighted in red.
[TABLE="width: 150"]
<tbody>[TR]
[TD="align: center"]A
[/TD]
[TD="align: center"]B
[/TD]
[TD]B/A=
[/TD]
[/TR]
[TR]
[TD]101
[/TD]
[TD]213.59
[/TD]
[TD]2.11
[/TD]
[/TR]
[TR]
[TD]334
[/TD]
[TD]458.23
[/TD]
[TD]1.37
[/TD]
[/TR]
[TR]
[TD]266
[/TD]
[TD]430.86
[/TD]
[TD]1.62
[/TD]
[/TR]
[TR]
[TD]847
[/TD]
[TD]517.6
[/TD]
[TD]0.61
[/TD]
[/TR]
</tbody>[/TABLE]
I've tried creating a conditional formatting for column A, like =IF(B2/A2<1.1) or =IF(B2/A2>2), but it doesn't work and I need to include them together like =IF(B2/A2<1.1,IF(B2/A2>2)) and also affect the entire column, not just Row 2 (using/ not using "$" perhaps?).Can some one help me please. I'm clearly missing something or writing the formula wrong.
Thanks.