View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mgoo mgoo is offline
external usenet poster
 
Posts: 2
Default Help Please.....numbers reaching limits and cells changing col

Thats great, thanks Mke

"Mike H" wrote:

Hi,

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

"mgoo" wrote:

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