Conditional formatting based on another column

[charlotte89]

Good morning all,

I need to apply conditional formatting to column B, to highlight cells that show an increase from column A that is above a threshold (=B2>(A2+50)).
I have made a separate column (C) with the threshold limit (=A2+50), so it should just read =B2>C2

I want to apply this to the whole sheet, as my columns are greater than 10,000 cells, however I can only manage to get this to apply to a single cell.

Is there a way I can achieve the above?

See picture attached

 

[etaf]

selet column B
then use
=$B1>($A1+50))
and apply the formatting - you dont need C

for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting

Highlight applicable range >>
B:B - Change, reduce or extend the rows to meet your data range of rows

Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=$B1>($A1+50))

Format [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK

Book1
	A	B
1	A	B
2	233	268
3	200	235
4	300	355
5	600	635
6	800	835
7	100	155
8	490	525
9	520	555
10	550	605
11	580	615
12	610	645
13	640	695
14	670	705
15	700	735
16	730	785
17	760	795
18	790	825
19	820	875
Sheet1

Cell Formulas
Range	Formula
B2:B3,B5:B6,B8:B9,B11:B12,B14:B15,B17:B18	B2	=A2+35
B4,B7,B10,B13,B16,B19	B4	=A4+55

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B:B	Expression	=$B1>($A1+50)	text	NO