Hi Team,
i have coloumn A with Different status like Open, closed, available etc. Coloumn B have numbers.
i am looking for a formula in condition formating for coloumn B.
If the cell value in coloumn B is 2 or more, the same cell should be highlighted in Green.
If the cell value in coloumn B is 1, the same cell should be highlighted in Yellow.
If the cell value in coloumn B is 0, the same cell should be highlighted in Amber.
If the cell value in coloumn B is less than 0, the same cell should be highlighted in Red.
If the cell value in coloumn A is "Available", cell in coloumn B should be highlighted in Amber.
Please help
i have coloumn A with Different status like Open, closed, available etc. Coloumn B have numbers.
i am looking for a formula in condition formating for coloumn B.
If the cell value in coloumn B is 2 or more, the same cell should be highlighted in Green.
If the cell value in coloumn B is 1, the same cell should be highlighted in Yellow.
If the cell value in coloumn B is 0, the same cell should be highlighted in Amber.
If the cell value in coloumn B is less than 0, the same cell should be highlighted in Red.
If the cell value in coloumn A is "Available", cell in coloumn B should be highlighted in Amber.
Please help