Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print color command
I need help in writting a command in my file. I would like for a name to
print out in a certain color, when a certain amount is obtainned. Can you help me with this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print color command
Assume your name is in A1 and the amount is in B1. Select A1 and then
click Format | Conditional formatting. In the first box choose Formula Is rather than Cell Value Is, and in the next box enter this formula: =$B1500 Then click the Format button and choose your colour (for foreground), or click on the Patterns tab and choose your background colour (or both). When you are done click OK twice to exit the dialogue box. Now if B1 exceeds 500 your name will be coloured as you have set it. You can use the Format Painter icon to apply the format to other cells. Hope this helps. Pete On Dec 19, 4:55 pm, Pascale wrote: I need help in writting a command in my file. I would like for a name to print out in a certain color, when a certain amount is obtainned. Can you help me with this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print Command | Excel Discussion (Misc queries) | |||
How to format the extension less file to print with Dos's Print Command | Excel Discussion (Misc queries) | |||
How do I apply color in cells ..color now shown only in print prev | Excel Worksheet Functions | |||
Print Command | Excel Discussion (Misc queries) | |||
Print command box | Excel Discussion (Misc queries) |