Changing Cell Formating if a cell value equals value from a range.

**radionut** · 07-30-2013, 07:02 AM

Hi,
I am newbie in VBA. Could you please help me.

I want to change background color and make text inside the cell in Bold if a cell in one sheet is equal to the one of the values in a specific range. (In a file I provided cells in 'Main' Sheet has change it's color in correspondance to the range A1:A9 in 'Reference list' Sheet)

Thanks.

**Naveed Raza** · 07-30-2013, 07:06 AM

Hi radionut

you mean to say whatever the list is avaiable in Reference list sheet if that name is showed in main sheet then that required name row should be bold right.

**radionut** · 07-30-2013, 07:35 AM

Originally Posted by Naveed Raza

Hi radionut

you mean to say whatever the list is avaiable in Reference list sheet if that name is showed in main sheet then that required name row should be bold right.

Hi Naveed

Yes cell in Main containing the same value as any of the cells in Reference list should be bold and with different background.