Get instant live expert help on I need help with vba interior color

Architecture Interior Design Combined Hourly Rate Principal 15 5 18 $150 Sr. designer 25 35 40 $110 Drafter 40 30 60 $75 Administrator 5 5 8 $50

I want to count the colour in a range of cells and have it update count as colour changes occur Have tried this VBA but it does not update unless cell is changed from count-the-number-of-cells-with-specific-cell-color-by-using-vba

I need a VBA Code that sorts a table by 2 conditions. The first being G3:G252 by a single cell color at the top, the second being an ascending numerical value in the rang A3:A252. I want a VBA code, because this is dynamic data that will be altered.

I have a drop down list with 3 options (exterior, interior, electrical). If a selection of exterior is chosen, i would like another cell to calculate the sum of two other cells. How can i create?

VBA HELP (I already have done the fill color to yellow I can not figure out the next steps Using VBA, in column D of the worksheet, enter Invalid Part Number for a row that does not have a valid part number (one that begins with a letter). Change the Fill color to yellow. Next, part numbers that are even numbers are ones the firm produces itself, while ones that are odd numbers they purchase from an external source. Again, using VBA, for the valid part numbers display in column D, Ours for the ones we produce and Purchase for the ones we get from external sources.