Excel help

[mukeshc]

Hi

i am working on an excel query were i want to identify certain cell colour b and on the basis of that want next cell to be tagged as following:

If cell is yellow then next cell should be tagged as formulated
if cell is red then it should be tagged as average.

thanks in advance.

 

[oldbrewer]

if a conditional formatting formula makes a cell yellow, use the same formula to make next cell "formulated"

 

[mumps]

Is the cell colour filled in manually or is it the result of conditional formatting? In which column are the coloured cells? When you say "tagged as formulated" and " tagged as average", do you mean that you want either the word "formulated" or the word "average" placed in the adjacent cell?

 

[mukeshc]

is the cell colour filled in manually or is it the result of conditional formatting? In which column are the coloured cells? When you say "tagged as formulated" and " tagged as average", do you mean that you want either the word "formulated" or the word "average" placed in the adjacent cell?

yes i am filling cell colour manually.

 

[oldbrewer]

then change to conditional formatting - you must have a "rule" that tells you what color is required...............

 

[Joe4]

If you are manually highlighting the colors, and there is no "rhyme or reason" (pattern/logic) dictating which cells are being colored, you would need to use VBA to do what you want.

 

[mumps]

This macro assumes that your colored cells are in column B starting at row 2.

Sub ColorCells()
    Application.ScreenUpdating = False
    Dim LastRow As Long, rng As Range
    LastRow = Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
    For Each rng In Range("B2:B" & LastRow)
        Select Case rng.Interior.ColorIndex
            Case Is = 6
                rng.Offset(0, 1) = "Formulated"
            Case Is = 3
                rng.Offset(0, 1) = "Average"
        End Select
    Next rng
    Application.ScreenUpdating = True
End Sub

 

[JLGWhiz]

Or you could just put a legend at the top of the sheet that says Yellow means "Formulated", Red means "Average".