for 5 colors you need to use VBA to get it If four were acceptable use
Conditional formating (one default and three conditional)
I

"sip8316" wrote:

Can I have the Font color in a specific row be a certain color based on a
value in one cell in that row.

I am looking at data for different room types classified as A,B,C,D or E.
Each row is for a different room with one of those classifications. I want
the whole row to dislay one or five different font colors (respectivley)
based on the classification.

How can I do this,

Scott