09-11-2020 12:15 PM - edited 09-11-2020 12:19 PM
When selecting an option from a drop-down list, can conditional formatting be applied to the cell and change color based on the selected data?
09-11-2020 12:26 PM
Yes, but you'd have to create a separate rule for each individual value in the dropdown list.
Writing VBA code to color the cell might be more efficient.
09-11-2020 12:47 PM