Select Cell C1 | go to FORMAT | CONDITIONAL FORMATTING | in first dropdown
select, CELL VALUE IS | in second dropdown select, LESS THAN OR EQUAL TO |
in the third box, type 50 | click on FORMAT | go to PATTERN tab | select the
color | Press OK.


"Martin Murray" wrote in message
...
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