View Single Post
  #2   Report Post  
Old December 31st 05, 06:39 AM posted to microsoft.public.excel.misc
Peo Sjoblom
Posts: n/a
Default If formulation: Is it possible...

in B1 put


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


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.