Programatically sort and highlight

R

Rookie_User

I have a worksheet of data that is dumped from our ERP system. It will have
cells that look blank but actually have "spaces" in them, alot of cells look
like this. The structure is as follows.

Columns

A B C D
9 H 12/1/09 2.00
9 H 12/1/08 3.00
9 H 10/1/09 4.00
9 U 11/1/09 5.00
9 U 2/1/09 6.00
Total for

What I think I want to do is search for the words "Total for" which will
then give me the very last line of data. Then within this range from 1 - to
the row that contains "Total For" I want to look at each cell in column C and
if the date is over six months old I want the whole row (A-D) to be
highlighted in yellow. This way it will bring attention to the item. I had
tried a for/while loop but it was not working correctly. Please help
 
D

Dave Peterson

Maybe you don't need a macro...

Select the range A1:D### (or whatever)
With A1 the activecell
Format|conditional formatting|
formula is:
=(today()-$c1)>182
and give it the pretty format you like

This actually uses 182 days instead of 6 months.

Is that important?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top