Hi Mick,
There is a feature in Excel called "Conditional Formatting" and it
cannot change the value or the numberformatting of any cell.
It can change the font, colors, and patterns in a cell. Remove the
C.F. and it is revealed that no actual changes were made to the cell.
Nor is Excel equipped to have a value in a cell but display
a different value based on a formula.
I would suggest that you set up a helper column (an additional
column) and put your formula in there based on another cell.
You can perhaps hide the column with the true value, if you
don't have to make entries into it.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
Hi all, Is it possible to conditionally format a cell with numbers.
I need a formula that will give a minimum value in a cell yet still allow a
true value if it is over the minimum. Any help will be great, thanks in
advance.
Mick.
