carrellim
06-03-2011, 09:56 PM
I hope this doesn't sound complicated :dunno I'm new here to VBAX so hi to all of you (currently working on a IS project for Toyota so any help is appreciated I'm sure I'll be here a lot!! I'll try and give back as much as I take.) (open)
So I set up an interesting spreadsheet that lets users enter in price information and then can click an "archive" button which then inserts a new cell, prompts for an archive name, and then stores it as a database which access then queries for the mass amounts of information. (summary)
The archive in column E:E has a bunch of price information and when the user clicks "archive" it then needs to compare the cells in F:F (archive location) to the old archive (now G:G) to show any price changes with a color. (Problem)
I need to compare each cell to the cell next to it and if they equal then change the new archive cell to yellow (to show no changes). I started an If Then Else function for each range but that's tedious and needs to be programed for each individual cell *yawn*
And lookup function on conditional formatting that says if cells("E:E") = cells("F:F") then color that cell yellow.
Thanks for all your help!
So I set up an interesting spreadsheet that lets users enter in price information and then can click an "archive" button which then inserts a new cell, prompts for an archive name, and then stores it as a database which access then queries for the mass amounts of information. (summary)
The archive in column E:E has a bunch of price information and when the user clicks "archive" it then needs to compare the cells in F:F (archive location) to the old archive (now G:G) to show any price changes with a color. (Problem)
I need to compare each cell to the cell next to it and if they equal then change the new archive cell to yellow (to show no changes). I started an If Then Else function for each range but that's tedious and needs to be programed for each individual cell *yawn*
And lookup function on conditional formatting that says if cells("E:E") = cells("F:F") then color that cell yellow.
Thanks for all your help!