Posted by Dana on July 24, 2001 4:38 PM
I am having a problem with conditionaly formatting in Excel 2000. I am using an offset formula to bring the data into a cell. This cell will change as I change a pulldown menu. For example, sometimes it will contain a percentage, sometimes a currency value, sometimes a number. I want to graph this cell value, so I need it to be conditionally formatted. The people who see this sheet will not want to go into every cell and format the cells manually as they change the pulldown.
I know how to use conditional formatting to format color, border, font, etc....but I need to change the NUMBER format. Does ANYone know?