IF funtion to result in cell colouring

P

Peta

Need help to asign colours to cells using muliple IF function. Can anyone
help with what code to use please?
 
E

Eduardo

Hi Peta,
Use conditional formating, highlight the range you want to apply the
different colours and then in conditional formating with formulas use the
condition you want to apply. i.e. =A1 >1 colour yellow, A1>5, red etc
 

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

Is it possible to edit colours already saved as part of a custom theme? 0
How can i put text in a cell depending on colour 0
How many rows are coloured 1
Counting coloured cells 3
Help on "Highlighting" and "Font Colour" functions 1
Change the colour of a cell if another named cell is blank 2
how to link horizontal data to vertical cells in a new sheet 1
conditional formatting update issue 5

Top