Syntax for number range in conditional formatting

Hi, welcome to the forum

That is pretty straight forward.

1. highlight the range you want to apply the conditional formatting to
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =$A2>220 format fill your color choice

repeat 3&4 for the other rules...
=A2>110
1A2<=110

Make sure the rules are this same sequence (largest to smallest), and check "stop if true"

Originally Posted by Suzanne Irene

Thanks so much for the quick response. Don't I need to put a range of numbers in like: 0-110; 111-220; 221-330? AND what does the $ signify...do I need to include it?

No, you dont. By looking for the highest number 1st =$A2>220, you effectively screen out all the lower numbers.
Then when you use =A2>110 you again, screen out all the numbers below that. And keep in mind, the >220 has already taken care of the higher values.
So, all thats left if =A2<=110

The $ effectively "locks" the column, so that you can copy that across to other columns, and the "A" part wont change (so you can apply color to a row of cells, instead of just 1 cell)

Sorry but I am still unclear as to how to enter this info as the 3 color bar option (using Mac Excel 2011) doesn't allow for the coding you've provided. The classic option seems to only allow one condition per cell so what am I missing here?

hmm I dont use Mac, so Im not sure what the CF window there looks like. But the main thing is, you need to use the "Use Formula" rule, not any of the others

OK, can you upload your file here (as long as it contains no sensitive data)?
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.