Hey everyone,
I'm currently working on a project similar to this practice one I thought I'd try my hand at. The goal is to not use a chart and be able to shade into the next worksheet the values given on the worksheet before. Alright that probably was more confusing then needed to be so I'll just explain via the excel sheet provided down below. So on Worksheet one aka named Listing I have the total price on D13 which is $875.52, I wanna use that cells value and transfer it onto my second worksheet Budget Meter. Over there you see 10 boxes each boxes is separated by increments of 100 dollars. is there a way I can have it highlight 8.75 boxes? If so do you know what the formula would be? I've got a feeling its going to be conditional formatting but I am not quite sure what the formula would be or how I would go at it. Or would this be something only VBA could tackle? Any input suggestion or edits will be much appreciated.
Dreambuild.xlsx
Bookmarks