If formulation: Is it possible...
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.
|