Making a Rule?

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"