Conditional formatting for numbers
Posted by John Unger on November 26, 2001 3:14 PM
How do I get a column of cells to reduce/add a decimal place if the number is a particular value? I.e., if a cell in column B is "100.0%", I'd just like to show "100%" for that cell, and leave the other cells in the column with the format of "#.0%". There are other instances where if a cell value in a column is less than 0.05, I'd like to be able to display it, but still have the rest of the column rounded to the tenths decimal place. Thanks for taking my question.
John Unger