Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional format of data tables in charts | Charts and Charting in Excel | |||
Protected cells -automatically format to a different color | Excel Discussion (Misc queries) | |||
conditional formating - Highlighting text cells based on sales res | Excel Discussion (Misc queries) | |||
formating text cells | Excel Discussion (Misc queries) | |||
Cells losing formatting | Excel Discussion (Misc queries) |