For simplicity assume your stock values start in A2 and your store names
start in B2
instead of using cell value equals in conditional formatting use formula is
and

=$A2=0

assuming 0 is the value, if it is blank replace 0 with ""
now select A2 and click the paintbrush icon and "paint"
the rest of the cells



--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"ANDREW_B" wrote in message
...
Hi..

Ive got a set of sales figures next that relate to specific stores we are
selling our products in.

Ive managed to conditionally format cells where no stock has been sold,
but
I want to highlight the name of the store that has not sold any stock. How
do
I do this? Please help me Im going out of my mind!!

Thanks