colour cell according to if criteria met

  • Thread starter Thread starter dw
  • Start date Start date
D

dw

HI Is it possible to highlight the colour of a cell dependent upon it
meeting certain criteria. I want to show all cells which are greater
than 0 as green and those less than 0 as red. Is this possible? All
help appreciated.
cheers
David
 
HI Is it possible to highlight the colour of a cell dependent upon it
meeting certain criteria. I want to show all cells which are greater
than 0 as green and those less than 0 as red. Is this possible? All
help appreciated.
cheers
David
Click to expand...

Look at conditional formatting

Format > conditional formatting, does what you want
The help or F1 will give you examples if your unsure.
 
Back
Top