colour cell according to if criteria met

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
 
D

Dewi...

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.
 
D

dw

Look at conditional formatting

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

many thanks, got it!
DAVID
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Conditioning Formatting 3
Excel Colour code dates 1
Cell colour change if formula displays false 3
Changing a cell colour if target not met. 4
Fill-colour a cell dependent on formula 1
Setting cell fill colour 2
Change Row Colour if certain criteria is met 2
Mail Merge With Colour Function 2

Top