Re: $$Excel-Macros$$ Re: Conditional Format Entire Row if Any Column has a specific value

2013-02-06 Thread John A. Smith
for the specified value >>> highlight the row (in any way you wish) >>> >>> but that is not a formula. >>> >>> >>> >>> *Paul* >>> >>> --------------------- >>> *“Do all the good you can, >>> By all the means you can,

Re: $$Excel-Macros$$ Re: Conditional Format Entire Row if Any Column has a specific value

2013-02-05 Thread The Viper
all the places you can, >> At all the times you can, >> To all the people you can, >> As long as ever you can.” - John Wesley >> *- >> >> >> -- >> *From:* JohnA >> *To:* excel

Re: $$Excel-Macros$$ Re: Conditional Format Entire Row if Any Column has a specific value

2013-02-05 Thread John A. Smith
> In all the ways you can, > In all the places you can, > At all the times you can, > To all the people you can, > As long as ever you can.” - John Wesley > *------------- > > > ---------------------- > *From:* JohnA > *To:* excel-macros@googlegroups.com > *Sent:* Tue, February 5, 2013 1:56:21 PM > *Subjec

Re: $$Excel-Macros$$ Re: Conditional Format Entire Row if Any Column has a specific value

2013-02-05 Thread Paul Schreiner
cros@googlegroups.com Sent: Tue, February 5, 2013 1:56:21 PM Subject: $$Excel-Macros$$ Re: Conditional Format Entire Row if Any Column has a specific value I wasn't clear enough so I created an example of my question.  Thank you all for quick responses. My target value can be in none or

$$Excel-Macros$$ Re: Conditional Format Entire Row if Any Column has a specific value

2013-02-05 Thread JohnA
I wasn't clear enough so I created an example of my question. Thank you all for quick responses. My target value can be in none or one or many of the 180 columns, not interdependent on each other, and not in the same column on different rows. Please see the attached example for a more clear

$$Excel-Macros$$ Re: Conditional Format Entire Row if Any Column has a specific value

2013-02-05 Thread Shekhar
Hi John, Please find attached file which has conditional formatting based on criteria you have mentioned. Thanks and regards, Shekhar On Tuesday, February 5, 2013 8:35:08 PM UTC+5:30, JohnA wrote: > > I have a spreadsheet with 180 columns and 8,000 rows. I would like to > highlight a row i