Advice on Creating an Excel Formula or Macro - PLEASE HELP!!!!


G

Guest

In Excel 2000 - I need to create a formula or macro that will pull values,
from a column, based on color (or text if color won't work). Conditional
formatting will color a cell based on a condition but I need to be able to
define a condition based on either color. For example, a specific color is
in cell a1, a3, & a5 the value is in a2, a4, & a6. I need to create a formula
or macro in cell a7 that will add the values from a2, a4, & a6 based on the
condition (color) in cell a1, a3, & a5.
 
Ad

Advertisements

B

Bearacade

This is very crude, I hope it helps.

I use the light yellow color as base, change as needed



Sub Macro1()

Dim temp As Integer

If Range("A1").Interior.ColorIndex = 36 Then temp = temp
Range("A2").Value

If Range("A3").Interior.ColorIndex = 36 Then temp = temp
Range("A4").Value

If Range("A5").Interior.ColorIndex = 36 Then temp = temp
Range("A6").Value

Range("A7") = temp

End Su
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top