Forum Discussion
Color coded dropdown lists
Let's say your drop-down list has options One, Two and Three, and you want to color the cell red, yellow or green depending on the selected item.
Select the cell or cells with the drop-down.
On the home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Format only cells that contain'.
Leave the first drop down set to 'Cell Value'.
Select 'equal to' from the second drop down.
In the box next to it, enter the formula="One"
Click Format...
Activate the Fill tab.
Select red as highlight color.
Click OK, then click OK again.Repeat these steps, but with ="Two" as formula and yellow as fill color.
Repeat them again, with ="Three" as formula and green as fill color.
That's really strange. Did you see what is the actual limit, 1 reply, 10 replies, etc.? Based on our experience here replies could go one by one.
I see, thank you. Most probably that depends on user profile, one limit for Occasional Visitor and other limits for higher ranks. have no answer, you may clarify that on https://techcommunity.microsoft.com/t5/community-lounge/ct-p/Community-Info-Center.
Anyway, from my point of view 8 message in 4 hours is quite strong.
