| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can colors be used in if test results eg red for minus amounts
IN WRITING IF TESTS IWOULD LIKE TO HAVE THE RESULT PRINT IN RED FOR NEGATIVE
NUMBERS AND BLACK OR GREEN FOR POSITIVE. CAN THIS BE DONE. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can colors be used in if test results eg red for minus amounts
John,
First off kill the caps, it's hard to read and is considered rude. Format your formula cell with this [Green]#,##0;[Red]-#,##0 Mike "JOHN13" wrote: IN WRITING IF TESTS IWOULD LIKE TO HAVE THE RESULT PRINT IN RED FOR NEGATIVE NUMBERS AND BLACK OR GREEN FOR POSITIVE. CAN THIS BE DONE. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can colors be used in if test results eg red for minus amounts
Yes. Check out Conditional Formating.
-- Regards, PJ Please rate this post using the vote buttons if it was helpful. "JOHN13" wrote: IN WRITING IF TESTS IWOULD LIKE TO HAVE THE RESULT PRINT IN RED FOR NEGATIVE NUMBERS AND BLACK OR GREEN FOR POSITIVE. CAN THIS BE DONE. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Minus Key Results in EXT Message in Status Bar | Excel Discussion (Misc queries) | |||
| Listing values minus the zero amounts | Excel Worksheet Functions | |||
| test a range of dollar amounts to assign a commission value | Excel Discussion (Misc queries) | |||
| Cell total plus and minus amounts | Excel Discussion (Misc queries) | |||
| Interpretation of T test results | Excel Worksheet Functions | |||
Hybrid Mode
