Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fill Cell with Colour if Q
Is there VBA code that will fill a cell with a certain colour, say yellow, if another cell = value of any one of 5,6,100,175,101 etc
I have the array list in a Range (called 'Products) and I want to easily see these products on a Sales mix report? So Column E contains the Product Number; Col F Contains Product Name, which I want to fill with a colour, and Col M contains Qty Sold, which I'd like also to fill with a colour |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fill Cell with Colour if Q
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fill Cell with Colour if Q
Fantastic Claus (again) works like a dream
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fill Cell with Colour if Q
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fill Cell with Colour if Q
Thanks Claus, I'll have a look at that one, although with 2,500 rows the previous one did it in the blink of an eye
|
#6
|
|||
|
|||
|
#7
|
|||
|
|||
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can you flag a cell with fill colour | Excel Programming | |||
cell colour fill | Excel Discussion (Misc queries) | |||
Setting cell fill colour | Excel Programming | |||
Active Cell Fill Colour | Excel Programming | |||
Changing Cell Fill Colour | Excel Discussion (Misc queries) |