is there a way to conditionally format a cell? Not just run a 'if' or 'case' statement such as this one:
When my calculation sheets are created I use test data, so some of my numbers will not be as large, or small as they can be, and as the numbers in the calculations change I don't want to rerun my formatting or a macro. I want a true conditional formatting on each cell.HTML Code:
for example:
M23 might be 953.01456 when I make my calculation sheet, but some instances it might be 10,546.8916.... but I only want to show 10,546.89 where I want to show all of 953.01456 (or 4 decimals of it)
Bookmarks