HELP ME PLEASE!! CONDITIONAL FORMATING HIGHLIGHTING CELLS.
 

Conditional Fomating question

I need to highlight an induvidual store name in a cell that has sold 0 stock.

Please see some example of the data below.

Store Id Store Item 1 Item 2 Item 3 Item 4 etc etc through to 18
2 London 2 3 1 0 0 0000000
4 Exeter 0 0 0 0 0 0000000
27 Ireland 1 0 0 0 0 00000000


The list is 400 stores long. I need to higlight stores that have sold 0
items.
So in this case it would colour the Exeter cell text only in red as this
store had sold
zero products for that week.

Thanks in advance

Hi
- select B2:B400
- goto the conditional format dialog
- enter the formula
=SUM($C2:$X2)=0
- chhose your format

--
Regards
Frank Kabel
Frankfurt, Germany

"ANDREW_B" schrieb im Newsbeitrag
...
Conditional Fomating question

I need to highlight an induvidual store name in a cell that has sold
0 stock.

Please see some example of the data below.

Store Id Store Item 1 Item 2 Item 3 Item 4 etc etc through
to 18
2 London 2 3 1 0 0
0000000
4 Exeter 0 0 0 0 0
0000000
27 Ireland 1 0 0 0 0
00000000


The list is 400 stores long. I need to higlight stores that have sold
0
items.
So in this case it would colour the Exeter cell text only in red as
this
store had sold
zero products for that week.

Thanks in advance