Nov 23 2020 02:35 PM
Hi all,
I'm looking for help with a conditional formatting issue. I want to shade cells a different colour according to the value selected from a drop-down list (there are four options, so I need a rule that dictates which colour to shade the cell based on the option chosen). I can't find anything in the online help. Can anyone here help?
Nov 23 2020 02:42 PM
You'll have to create four different rules, one for each drop-down option.
Select the cells that have the drop-down.
Repeat the above steps with the second option and a different color.
Same for the third and fourth option.