| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using 3 coloured Cells to Format a 4th Cell
Please can you help me with the following problem:
I have three cells: L5, Q5 and V5, which when I colour green, then I would like for cell AD5 to be automatically coloured green and a number 1 be placed in it. If on the other hand cells L5, Q5, V5 are any other colour, then cell AD5 should be coloured red and a zero to be placed in it. Please can you help me to devise a method of doing this. Many thanks for your help and support, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding sum of coloured cells | Excel Discussion (Misc queries) | |||
| sum coloured cells | Excel Discussion (Misc queries) | |||
| Coloured Cells | Excel Discussion (Misc queries) | |||
| Counting coloured cells | Excel Discussion (Misc queries) | |||
| Summing only coloured cells | Excel Worksheet Functions | |||
Threaded Mode
