CONDITIONAL FORMATTING

[HVK1986]

I have 5 values in A column and 5 values in column B.

A column B

1 10%

2 20%

3 30%

4 40%

5 50%


i hve data validated the values in A.

Now if i select 1 in A, the 10% should get bold, if 2 then 20% should get bold..like wise...


Pls help

 

[Faseeh]

Hi Harry,


Create two conditional formatting rules:


First: =(A2=$A$1)=TRUE

Second: =($A$1=OFFSET(B2,0,-1))=TRUE


Set font to bold. The first rule applies to First column and second to the second column. Your data is in A1:B6 and the data validation list is in A1.


Regards,