If formulation: Is it possible...
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. |
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. |
If formulation: Is it possible...
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. |
If formulation: Is it possible...
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. |
All times are GMT +1. The time now is 09:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com