Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Change Font Color Based on Classification
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
I read a thing online and figured this out.
THanks "sip8316" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change font in a forms control combo box | Excel Discussion (Misc queries) | |||
How do I change default font for all new comments in Office 2003? | Excel Discussion (Misc queries) | |||
change font when sheet is protected | Excel Discussion (Misc queries) | |||
How do I get the font color to change automatically depending on | Excel Discussion (Misc queries) | |||
How to change the default font and size of "comments"? | Excel Discussion (Misc queries) |