Excel Help

[BenWall]

Hey guys,

This should be a simple one.

I want certain cells to be certain colour depending on the value within them.

For example - anything below 20 is green and anything above is red.

I'm guessing this is a simple (IF) formula which will be contained within hidden cells?

 

[AK]

What's it for?

You can do it but Would an "x" in another cell next to the number not be better? Then you can filter on all containing X or all not containing X..

Really depends what the spreadsheet is for..

I'm not good at colour conditional formatting

 

[ChrisH]

You just need conditional formatting mate

 

[BenWall]

Chris.. hello.

Thanks bud, just what I was after.

 

[ChrisH]

Hi, np, ring me if you need to