Color Change Depending on Text Input

November 29, 2012 at 12:15:04
Specs: Windows XP

Hey,
I need a macro to change the color of a specific row depending on the specific text that is input in cell in that row. So I have like 5 words that depending on what word I put in the specific cell that row is than changed to a specific color. Anyone help??

See More: Color Change Depending on Text Input

Report •


#1
November 29, 2012 at 13:20:02

From your brief description, it sounds like you could probably use Conditional Formatting to do what you want in place of a Macro.

MIKE

http://www.skeptic.com/


Report •

#2
November 29, 2012 at 13:36:39

I need more than 3 conditions so I'm pretty sure I need a Macro....

Report •

#3
November 29, 2012 at 13:42:40

If your using 2000 or 2003 that is true, if your using 2007 or 2010 you do not have that limit.

MIKE

http://www.skeptic.com/


Report •

Related Solutions

#4
November 29, 2012 at 13:47:21

Yes, I'm using an older version.

Report •

#5
November 29, 2012 at 15:40:59

It is possible, if you use a Defined Name and the =COUNTIF() function

Post a short example of your sheet, with Column Letters and Row Numbers
After you Read this How-to:

http://www.computing.net/howtos/sho...

MIKE

http://www.skeptic.com/


Report •


Ask Question