Please refrain from all caps, it is considered shouting and thus rude,
besides it is harder to read

for workaround and code see:

http://www.mcgimpsey.com/excel/conditional6.html

and you can download an add-in here

http://www.xldynamic.com/source/xld.....Download.html


Regards,

Peo Sjoblom



"HELP NEEDED" wrote:

I WOULD LIKE A CELL TO RETURN A DIFFERENT COLOR FOR EACH OF MY SIX
CRITERIA,ANY IDEAS?