Formula's

[Quif210786]

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

 

[Mike H]

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

 

[ShaneDevenshire]

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.