Hi!

A1 = 41.75

Enter this formula in B1:

=IF(A140,A1-40,"")

Select cell B1
Goto FormatConditional Formatting
Select: Formula Is
Enter this formula in the box:

=LEN(B1)

Click the Format button
Select the style(s) desired
OK out

Biff

"OSCAR" wrote in message
...
tHAT DIDNT WORK. i WOULD LIKE THE CELL TO SHOW THE GREATER VALUE ONLY.

"Peo Sjoblom" wrote:

in B1 put

=A1

then select B1, do formatconditional formatting, cell value greater
than
40

--
Regards,

Peo Sjoblom

(No private emails please)


"OSCAR" wrote in message
...
That if a value is greater than 40.00 in a particular cell, that the
value
greater than 40.00 show up in another cell in a different color?

for example if A1 cell value is 41.75, then B1 cell will show 1.75 in
red.