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.
I'm afraid a screenshot doesn't help. See my previous reply.
- Thank you. that worked.
Thanks. Since you want to highlight cells on the 7 Oct 24 sheet, you should create the rule(s) on that sheet:
- Activate the 7 Oct 24 sheet.
- Select A5.
- On the Home tab of the ribbon, select 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.
- Type = in the box next to it, then point to cell A30 on the PROJECT LIST sheet. You should see ='PROJECT LIST'!$A$30
- Click Format...
- Activate the Fill tab.
- Select a color.
- Click OK.
- If necessary, repeat for other project names, with different colors.
- With A5 on the 7 Oct 24 sheet still selected, double-click the Format Painter button on the Home tab of the ribbon.
- Click on A6:A16, then on A18:A32, then on A34:A45, etc. to copy the formatting.
- Press Esc when you're done to turn off the Format Painter.
- i think i sent it via private message?
I do not see a link to a file
- in the 'project list' is the list of the projects that i have worked on.
'7 oct 24' is the timesheet currently.
all are within a single file.
not sure if i did this correctly...i shared the file.