I want to conditional format an entire worksheet, where if the value in a cell is greater than the value in B of that row, the cell is highlighted. However, per line, the value in B is VARIABLE. Example: if in B2, the value is 100, any values in row 2 higher than this will be highlighted. If in B3, the value is 200, any values in row 3 higher than 200 will be highlighted. Values less than 200 but over 100 should not be highlighted in row 3, as they should NOT be affected by the formatting copied down from row 2. Conditional formatting needs to understand the X variable for Greater Than in column B is changing PER ROW. I can make this work by clicking each row and applying formatting manually, however there are several thousand lines of data to format, and I need this to go quicker.
Solved by B. F. in 27 mins