Help Please.....numbers reaching limits and cells changing colour

  • Thread starter Thread starter mgoo
  • Start date Start date
M

mgoo

Hi. Can anyone help?

How can I set up cells so that when that cell reaches a number the cell will
change colour. This is so that I can have an indication as to when a certain
part of a budget is over or reaching limit.

Thanks
 
Hi,

Select the cell then
Format|Conditional formatting
Cell value is
Greater than
Input your desired value and select a colour
Click OK
 
Thats great, thanks Mke

Mike H said:
Hi,

Select the cell then
Format|Conditional formatting
Cell value is
Greater than
Input your desired value and select a colour
Click OK
Click to expand...
 
Back
Top