Highlighting cells

  • Thread starter Thread starter Martin Murray
  • Start date Start date
M

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
 
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.
 
Back
Top