I have a sheet with several columns. I need to highlight a cell that is the top based on another cell.
example:
column A column B column C
1 2 3
2 4 2
1 1 2
1 4 6
Based on the above values, the value 4 needs to be highlighted if the value in col A is = 1.
How should I go about it to get the desired result?
example:
column A column B column C
1 2 3
2 4 2
1 1 2
1 4 6
Based on the above values, the value 4 needs to be highlighted if the value in col A is = 1.
How should I go about it to get the desired result?