Making a Rule?

Like this...

Select the *entire* range B58:B63 starting from cell B58.
Cell B58 will be the active cell. The active cell is the
one cell in the selected range that is not shaded. The
formula will be relative to the active cell.

Goto the Home tab>Styles>Conditional Formatting>
Manage rules>New rule>Use a formula to determine
which cells to format

Enter this formula in the box below:

=B$6=1

Click the Format button
Select the desired style(s)
OK out

You would need an event macro for this.

Tell us the EXACT range of cells that you want this to apply to and what color do you want to use?

I'm not much of a programmer but I think I can handle this.

For the last question.. Try this..

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = Range("A11").Address Then
Target.Interior.ColorIndex = 4
End If
End Sub

Copy this code and Press Alt + F11 then click "sheet1" on the tree structure on the left hand side..
the paste the code there...
now if you select the cell A11, the cell color will change to green..

you can change the color by changing the color index no in the code..provided..

Try the below formula in conditional format, open the attachment select b6 and f2 and enter


=CELL("ADDRESS")="$B$6"

You need an event macro.

I'm not much of a programmer but this works for me.

Assuming you want to select a cell in the range B2:B10 and have the corresponding cell in A2:A10 fill color change to yellow.

Select the sheet where you want this to happen
Right click the sheet tab and select View code

This will open the VB editor

Copy the code below and paste it into the right side of the window that opens.

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
        With Target
            If .Count > 1 Then Exit Sub
            If Not Intersect(Range("B2:B10"), .Cells) Is Nothing Then
                Application.EnableEvents = False
                .Offset(0, -1).Interior.ColorIndex = 6
            End If
                Application.EnableEvents = True
         End With
End Sub

Close the VB editor to return to Excel

Try it out

Not sure I understand.

You can select a cell with your mouse, which is a mouse click, and have the cell fill color change.

Can you be more specific?

It sounds like you simply want to select a cell in some range and when selected, have that cell fill color change.

Is that what you want to do? Tell us the EXACT range that this should apply to.

This can not be done using conditional formatting. You have to use an event macro.

Short answer, no.

You're welcome!

Good luck!