| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If formulation
If you mean any cell in the range A1:A10 is greater than 40.00? Select
A1:A10, do formatconditional formatting cell value is greater than 40, click format and select red fonts and click OK twice If you mean the sum of A1:A40? Select the cell with the formula =SUM(A1:A10) do the same formatting -- Regards, Peo Sjoblom (No private emails please) "OSCAR" wrote in message ... what would be the formula for cell A1 thru A10 equaling more than 40.00 the result turns red? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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) | |||
| cell in cell formulation possible??? | Excel Discussion (Misc queries) | |||
Threaded Mode
