Hi Team,
Need help on below :
i have the data in one sheet starting from 1 to 90 and there is a input cell where i am passing a input value (should be between 1 to 90)
now based on the value which i entered in the input cell (example : 35), then the corresponding cell value which has number 35 should be highlighted in some color (say Green in color)
next time if i change the value in Input cell (example : 90) , then the color which was highlighted earlier for 35 should not be change the color from green to white, and the cell which has the number as 90 should be turned to Green in color.
i have also attached the input data for the reference. can you please help me on this.
Regards,
Kamal M.
Bookmarks