Change Format of Cells, selected cells....

Hello

I would like to change a format of certain cells when a cell from that row or column is selected, can anyone help?

i.e if any cell in row 3 is selected, then cell A3 to be bold

If anyone can help I will be grateful, see attached sheet.

Best wishes,

James

Hi there,

Sure it's possible - just see the attached.

It works by defining a named range "DataArea" (the yellow area) & using the VBA "Worksheet_SelectionChange" routine as a trigger. If the selected cell lies within the named range the "NewFormat" routine is called & the selected title cells are reformatted, otherwise (the selected cell is outside the named range) the "OldFormat" routine is called & all title cell formats are reset.

Please let me know if you need anything further.

Best regards,

Greg M

Absolutely perfect, many many thanks.