Change Font Color Based on Classification

S

sip8316

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
 
B

bj

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

sip8316

Thanks,

I was playing around some and just realized that. So I guess Im doing it in
VBA. If I could get some help that would be great, I haven't used VBA since
High School.

How would you suggest setting it up (like If then statements, etc.) and what
word or function do i type to change Font in VBA.

Any help would be great,

Thanks,

Scott
 
Top