How to highligh some required values in excel

How to highlight some required values in excel

I want to highlight some values that are present in a column please provide me formula for it….. thanks ( an excel file is attached for your ease)

Hi

Please check the attachment for solution

Regards,

Veejar

i need formula like as a conditional formatting....... so that after selecting the values i could apply formula to get required highlighted values :-(

In my sheet there two columns with values

Column B are the values for which you want conditional formatting
and column D has the values which you want lookup in Column B and highlight

In conditional formatting
select the cells that you want the rule to apply

and select using formula option and enter the following formula
=IF(COUNTIF($D$1:$D$4,B1)>0,TRUE,FALSE)

I am presuming that you understand countif functionality pardon me for that

regards,

veejar