Can anyone help me with this...

When a cetain number is reached in a cell using sum, can i get a cell to go
a certain colour.

For example, when the number 50 is reached in a totals cell, can another
cell then go gold, or blue, etc.

Thanks

Hi,

Click on the cell you want to change colour then
Format|Conditional formal
Select 'Formula is'
Enter the formula
=$A$1=50
Change A1 to the cell you are monitoring
Pick a colour
OK.

Mike

"Quif210786" wrote:

Can anyone help me with this...

When a cetain number is reached in a cell using sum, can i get a cell to go
a certain colour.

For example, when the number 50 is reached in a totals cell, can another
cell then go gold, or blue, etc.

Thanks

Hi,

If you are using 2007:
1. Select the cell you want to format, say A1
2. Choose Home, Conditional Formatting, New Rule,
3. Pick Use a formula to determine which cells to format
4. in the Edit the Rule Description area enter the following formula:
=$A$1=$B$6
where cell B6 contains your sum formula.
5.Then click the Format button and pick the Fill tab and choose any color
you want.
--
Thanks,
Shane Devenshire


"Quif210786" wrote:

Can anyone help me with this...

When a cetain number is reached in a cell using sum, can i get a cell to go
a certain colour.

For example, when the number 50 is reached in a totals cell, can another
cell then go gold, or blue, etc.

Thanks