Format Priority (Low, Medium, High) with colors

[CC268]

Hey guys,

EDIT: I was able to figure this out already with conditional formatting (or at least using green, yellow, and red colors).

In column E of my "to do list" spreadsheet I have ranked priorities (Low, Medium, High). How do I make it so that if the cell says Low it is green, if Medium it is orange, and if High it is red? My guess is you can do this easily with conditional formatting.

Thanks

 

[lscott214]

Use conditional formatting, custom rule, style = classic, format only cells that contain Specific text, containing Medium Format with choose custom and select fill, font and outline