Highlighting Data

[howard]

I have Branch names in column A and Values in columns B to H from row 6 to 25

I would like to set up consditional formatting if possible that where there are values highlighted to the right of say A6, for eg D6, then A6 may also be highlighted

Your assistance will be most appreciated

 

[marka87uk]

Choose Formula Is and then enter the condition where you want the cell highlighted, e.g.

=D6=TRUE

 

[howard]

Thanks for the reply. I am using office 2007 and cannot find "Choose Formula Is " on the conditional formatting ribbon


Attached please find sample data. I was like the data in column A highlighted if any of the data to the right of it in Column B to K has been highlighted

Your assistance will be most appreciated

Condt Formating Sample Data.xlsx
	A	B	C	D	E	F	G	H	I	J	K
6	BR1	11,417	17	10,442	12	5,753	33	11,423	14	10,210	83
7	BR2	13,011	12	15,246	9	5,302	21	6,662	11	9,391	61
8	BR3	16,360	9	12,722	6	5,384	19	8,643	3	11,202	42
Sheet1