I don’t see any way to do this, but I thought I would ask to make sure no one else has found a way. I have a spreadsheet with a column of numbers (imagine that!), the first of which is formatted with a “Currency” style number format, so that it has a dollar sign at the left side of the cell. The column consists of a series of formulas that pull in numbers from a “data entry” area of the sheet, and not all of the cells in the column will always have numbers, depending on the data that is entered in that other area. When the sheet is printed, any rows that don’t have data in this column are not included (this is done by means of a macro, that copies rows with data to yet another area, and then prints the parts that got copied). This means, if the first row with the Currency formatted cell has no data, the dollar sign at the head of the column is lost.
What I need to do is find a way for the first cell in the column that contains data to have the “Currency” formatting, so that it always gets copied to the print range. But Excel’s conditional formatting doesn’t appear to include any aspect of number formatting, or formatting by style. I had thought of trying to use a formula to add the dollar sign, but then it wouldn’t be left-aligned in the cell, would it? I am sure that I can find the proper cell and apply the “Currency” style via code, but before I start fiddling with the existing print macro, I wanted to check if there was another way to do this.
Thanks!
