View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Martin Murray Martin Murray is offline
external usenet poster
 
Posts: 2
Default Highlighting cells

Hi All

Can anyone help with this please?

Is it possible for a cell to automatically be highlighted if for example A1
cell has 100 in B1 cell has 51 in and cell C1 i have put =A1-B1 it then
shows 49 How would I go about getting it to highlight because it is 50 or
below?

I probably haven't explained this very well but thanks for any advice

Martin