Good morning (or evening) Excel/VBA wizards,
I am trying search through all sheets in a Workbook Price List and find all cells with prices (by cell formatting - see code below) AND the cell value is greater than 20 then add a price increase and roundup to the nearest dollar. Otherwise, if the price is less than $20, add the price increase and use the Ceiling formula to round to the nearest nickel. I would like for all prices that are over $20.00 and were increased to be formatted red, if less than $20 and increased than formatted green. A colleague sent me a UserForm that they use to increase prices but it was designed to increase all values by one amount. I do not really understand how to apply an if statement to a For each loop so first, I tried modifying the Macro by adding
and thought I would run the macro twice and just change the ">20" to "<20" but even the prices that are <20 were increased and formatted red. So below on the left is what I am ultimately trying to achieve.
2021-06-15 07_22_42-Clipboard.png. Please see below complete code and attached workbook. Thanks in advance.
Marvelous (not so much in vba!)
Bookmarks