View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RA RA is offline
external usenet poster
 
Posts: 53
Default 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,