Macro based on cell format?

[phrogg108]

Is there a way to do create a macro based on the format of the cell? Here is what I am trying to do:

I would like to "find all cells that are formatted as currency", multiply the current price that is in the cell by 1.04 and then =ROUND(cell_in_question,1). So, round to the nearest whole number.

Trying to do a price increase, then round it to the nearest whole number, but we also have descriptions of parts on the worksheets and I don't want to hit those cells. Just the ones with the prices in them.

If it's possible to do it to the whole workbook, I would love to know how to do that too.

I have never created a macro before of ANY kind, so be gentle.

Thanks for any info in advance!!!!!

 

[gbrandreth]

Just try this formula on every cell....

=IF(ISERROR(ROUND(A1*1.04,1)),"",ROUND(A1*1.04,1))

Result....
If the cel is a nr, it will be calculated, if its a desc, it will be blank

 

[phrogg108]

Is there a way to apply it to the whole workbook? Or do I have to do that cell by cell?

 

[phrogg108]

I tried that, but it is blanking my cells. They are formatted as currency to two places. Not sure if that is important or not....