excel formula question
 

Hello,
I am trying to write a formula for conditional format plug in from CFPlus,
I want it to highlight a different color every 500. From 500 to 1500. This
is for a column of subtotals of 40 cells.

Example:

500 in blue
1000 in red
1500 in green

Any help would be greatly appreciated
Thank you, Carol