Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If formulation | Excel Discussion (Misc queries) | |||
formulation of an expiry summary | New Users to Excel | |||
Multi - Level Question involving Data Mapping and Formulation | Excel Worksheet Functions | |||
Time formulation? | Excel Discussion (Misc queries) | |||
Simple Slope Formulation | Excel Discussion (Misc queries) |