Print color command

P

Pascale

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?
 
P

Pete_UK

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:

=$B1>500

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
 
Top