Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programatically sort and highlight
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programatically sort and highlight
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? Rookie_User wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Programatically sort and highlight | Excel Discussion (Misc queries) | |||
Programatically sort worksheet column | Excel Programming | |||
Sort Scenarios in List manually or programatically | Excel Programming | |||
Highlight Sort Column | Excel Discussion (Misc queries) | |||
Why when I go to sort does it automatically highlight from #1028? | Excel Discussion (Misc queries) |