Hi,
Can anyone help me to color the attached spreadsheet using conditional formatting.
D3:H22 is the range. The condition is if the value in the cell E3 is greater than the value in the cell D3, E3 should be in green. If the value in the cell E3 is lesser than the value in the cell D3, E3 should be in red. And the cell E3 is blank, it should colour yellow.
Likewise i need to colour D3:H33 based on this condition.
To be specific, the value in a cell is greater than the value in the adjacent cell (left side cell) it should colour green and if it is less colour red and if any cell is blank, colour yellow.
Bookmarks