Highlighting cells

[Martin Murray]

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

 

[Gaurav]

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.

 

[David McRitchie]

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