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