Excel Macro Row Highlighting 1

[Adammon]

I have a large spreadsheet (30,000 rows or so) of client data. It's been outputted as a simple CSV file and imported into excel where I'm massing it to make it look a little more presentable. The problem I've run into is I'm trying to highlight client-level information while leaving the specific information unhighlighted..IE


Account1 LastName1 FirstName1 Balance1
Product1 Cost1 Balance1
Product2 Cost2 Balance2
Product3 Cost3 Balance3
Account2 LastName1 FirstName1 Balance1
Product1 Cost1 Balance1
Account3 lastName3 FirstName3 Balance3

The number of products varies widely.
I want to be able to just highlight the Account rows, not the product information rows.

As far as I've figured it out in my own mind, I want to go row by row, determine if column A is null, if A is NULL don't highlight the row, otherwise DO highlight the row.

I can't seem to do this in the Advanced Formatting section, and Macro's aren't my speciality, any ideas?

 

[PHV]

Have you tried to play with conditional format (xl2k or above) ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Adammon]

Conditional formatting seems limited to a cell-by-cell basis, or the formula that you're allowed to enter is so limited as to be useless, unfortunately.

 

[TonyJollans]

Hi Adammon,

Conditional Formatting is actually quite flexible.

Select the whole sheet.
In conditional formatting, select "Formula Is" from the dropdown under Condition 1,
In the textbox to the right enter [blue][tt]=$A1<>""[/tt][/blue]
Choose your format and click OK

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[

 

[Adammon]

Perfect answer, thanks Tony. Saved me from having to write something myself!