Ya, so there's really 2 rules
make rule one
=if(or(cond1,cond2,cond3,cond4,cond4),true,false)
then format->pattern->green
rule 2
=if(or(cond1,...,cond15),true,false)
then format->pattern->blue
from what you've said it seems like your conditions will be prett
straightforward, so it might be as simple as
=if(or(a1=1,a1=2,a1=3,a1=4,a1=5),true,false)
the only tricky part remaining is to make sure you set your conditiona
formatting relative to the active cell. for example if you want to se
the conditional formatting to check the whole sheet for a value of 2
make a1 the active cell then select the region you want formatted. the
enter the formula as above
if you want to know which value in column a has that value then replac
a1 with $a1. if you want to know which values in the row 1 has tha
value replace with a$1