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

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

Hi Martin,
and since you would probably want to do that for more than one cell, with
the formula, such as cells in Column C, or even for the entire row it true for cell in Column C, you might want to take a look at
http://www.mvps.org/dmcritchie/excel/condfmt.htm
--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm


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