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