Highlight Cell
- Thread starter sambit
- Start date
NARAYANK991
Excel Ninja
Hi Faseeh / sambit ,
Using a formula to insert the value of the selected item on the sheet where the CF rule is to be applied , is not necessary ; all you need to do is create a named range referring to the selected item.
Thus if you create a named range called SelectedItem , referring to :
=Sheet1!$C$5
your CF rule can be :
=($C6=SelectedItem)
Narayan
Using a formula to insert the value of the selected item on the sheet where the CF rule is to be applied , is not necessary ; all you need to do is create a named range referring to the selected item.
Thus if you create a named range called SelectedItem , referring to :
=Sheet1!$C$5
your CF rule can be :
=($C6=SelectedItem)
Narayan