Anubhav Dhyani
New Member
Hi,
I have assigned a list of values in one cell (Drop down using Data validation) and I want different colors for different items in the list, for example, if completed is chosen the the cell should turn green and if pending is chosen the cell should turn red. can you please help me with the formula.
Thanks
I have assigned a list of values in one cell (Drop down using Data validation) and I want different colors for different items in the list, for example, if completed is chosen the the cell should turn green and if pending is chosen the cell should turn red. can you please help me with the formula.
Thanks