Automatically change fill colour of cells

[alanjenna]

Dear All

If I type "L" into cell F2 I have used conditional formatting to change the colour to red, I also want to change the fill colour of cells "G2 to M2" to red. I have tried using copy and paste using paste special, I have tried to use conditional formatting on cells "G2 to M2", I have also tried to create and run a macro but I cant seem to get it to work.

Any suggestions anyone.

Regards
Alan Johnson

 

[VoG]

Try like this: select F2:M2 and apply the conditional format

Excel Workbook
	F	G	H	I	J	K	L	M
2	L
Sheet3

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
F2	1. / Formula is =$F2="L"	Abc

 

[alanjenna]

Oh Mate
You are superb, thanks very much, it works .........

Once again, thank you very much ............

Alan Johnson