google-spreadsheetsmicrosoft excelspreadsheet
So I tried experimenting with conditional formatting, but unable to find a way to highlight the cells in the column if their value is greater than the one in the next column under the same row.
For example:
102 | 110 (highlight right cell)
130 | 120 (highlight left cell)
122 | 133 (highlight right cell)
How would I go about doing this?
You should use MAX($D$1:$D$4) instead, in your condition.
To highlight the whole row, you can select Formula is instead of Cell value is, and use the following formula: $D4=MAX($D$2:$D$4) (assuming you selected your block starting from A1 and ending in D4):
You would use the formula:
=G1>F1
Then you would apply it to All of Column G:
Best Answer
Here are the steps for Excel. Assuming the first value is in A1,
enter this formula into the formula box and take care with the dollar signs
=A1=MAX($A1:$B1)Click the Format button and set the desired format.
In Google sheets, select the cells, create a conditional format with "Custom formula is" and apply the same formula.