View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jolly Roger Jolly Roger is offline
external usenet poster
 
Posts: 1
Default Colour cell when number changes

If the number in a cell is changed and it is larger than the original number
I want the cell to be highlighted in a green colour. If the number is lower
than the original I want the cell to be highlighted in red.
Any suggestions gratefully accepted.
Roger