Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add a Button Programatically plus code | Excel Discussion (Misc queries) | |||
Excel should let me sort by highlight color. | Excel Worksheet Functions | |||
How to programatically control a 3D-sum? | Excel Worksheet Functions | |||
Highlight Sort Column | Excel Discussion (Misc queries) | |||
Why when I go to sort does it automatically highlight from #1028? | Excel Discussion (Misc queries) |