Condition 1 =
Cell Value Is: less than or equal to: 3
Condition 2 =
Cell Value Is: between : 4 and 20
Condition 3 =
Cell Value Is: greater than or equal to: 21

click the format for condition 1 and choose orange
click the format for condition 2 and choose blue
click the format for condition 3 and choose green

HTH

Die_Another_Day
Jeff wrote:
I have a problem with getting conditional formatting to work properly for
me.


What I want to do is use the cell background colour to indicate the number
of items in the cells (column)
I've spent hours trying to get it right :- (

If F2 is equal to or less than 3 (or cell is empty) 'to orange
If F2 is between 4 and 20 'to blue
If F2 is equal to or greater than 21 'to green

Solution gratefully accepted

Jeff