Hello all,
I need to assign particular number (1,2,3&4) based on the color in particular cell. Example if cell is colored yellow, the number 1 should come in cell, if cell is colored red, the number 2 should come in the cell.
Please suggest formula for the same.
Regards
Sanjay Dixit
I need to assign particular number (1,2,3&4) based on the color in particular cell. Example if cell is colored yellow, the number 1 should come in cell, if cell is colored red, the number 2 should come in the cell.
Please suggest formula for the same.
Regards
Sanjay Dixit