excel conditional formatting with values rather than colours

J

jamesjra

I need to do similar to conditional formating, except displaying a valu
rather than colouring the cell?

if the value of a1 is less than 0.99 inclusive, then display 0.15 i
b1
if the value of a1 is 1 or greater and less than 5, then display 0.2
in b1
if the value of a1 is 5 or greater and less than 15, then display 0.3
in b1
If the value of a1 is 15 or greater and less than 30, then display 0.7
in b1

Any help would be much appreciated

many Thank
 
F

Frank Kabel

Hi
this is only possible with VBA using an event procedure to change your
values after the entry in the cell. but why don't you use a helper
column (e.g. column C) and display the value using either IF functions
or VLOOKUP< and a lookup table?
 
D

Debra Dalgleish

Enter the following formula in cell B1:

=IF(A1<0.99,0.15,IF(A1<5,0.2,IF(A1<15,0.35,IF(A1<30,0.75,"Too high"))))
 
Top