Help..Conditionally formating a cell with numbers

  • Thread starter Thread starter Mick Worswick
  • Start date Start date
M

Mick Worswick

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.
 
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.
 
Thanks David ,I just had a go at that approach with a fresh linked cell and
it solves my problem
thanks again
Mick
 
Back
Top