Sep 11 2020 12:15 PM - edited Sep 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?
Sep 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.
Sep 11 2020 12:47 PM