How do you change the cell color associated will a cell value on an excel spreadsheet?

I have created a excel spreadsheet and used the vaildation function to have a drop down list for the values that can be added in a cell. I would like a background color to be associated with it value. This would be to show severity. IE low is green, medium is yellow, high is red.How do you change the cell color associated will a cell value on an excel spreadsheet?
use Conditional Formatting. I presume ';low';, ';medium';,';high'; is your source(value)





step1. select your validation cell(s)


step2. goto Format-%26gt; Conditional Formatting...


step3. Condition 1 =%26gt; CellValue is [select] equal to [input] low


step4. click ';format'; button


step5. select font color =%26gt; green, click ok


step6. Click ';Add%26gt;%26gt;'; button


step7. Condition 2 =%26gt; CellValue is [select] equal to [input] medium


step8. click ';format'; button


step9. select font color =%26gt; yellow, click ok


step10. Click ';Add%26gt;%26gt;'; button


step11. Condition 3 =%26gt; CellValue is [select] equal to [input] high


step12. click ';format'; button


step13. select font color =%26gt; red, click ok





you are ready to use your validation cell(s)


select value from your drop down listHow do you change the cell color associated will a cell value on an excel spreadsheet?
Under Format, Conditional Formatting, you can change the font and color based on the value in the cell
I hope I understand your question correctly. When you are looking at the excel spreadsheet, in the toolbar at the top, look to the far right. You should see a paint can with a little color under it. Next to that you see a letter A that is red. The paint can is for background color. Just choose the cell you want to add the color to and hit that little paint can arrow beside it (again to the right - upsidedown triangle) and you can change the colors to reflect whatever you need.
Highlight the cells you would like this to affect. Under the ';home'; tab, you will see styles click on ';conditional formatting';. Click on ';highlight cells rule';. Then click on ';text that contains';, there you will be able to type the text that you want, Then in the box next to it, you can choose what color or style you want. Repeat this for different cells and the different text or colors.





From http://www.themssforum.com/ExcelMisc/Aut鈥?/a>