Radio button click

[rupal1234]

How can i open contents like if i select for 1.5 then it should open the contents of 1.5
and if i select For 2.5 then i should open the

 

[chirayu]

I don't understand what you mea by open 1.5/ open 2.5

Open what?

 

[Lasantha]

See the attached

 

[rupal1234]

I don't understand what you mea by open 1.5/ open 2.5

Open what?

like if i check on for 1.5 then it should display 1.5 contents and if i check on for 2.5 thn it should display 2.5 contents

 

[rupal1234]

See the attached

Thankyou so much but let me know the process please .

 

[Lasantha]

Update cell link of radio button, before the relevant table.

 

[rupal1234]

how can i link table to buton

 

[rupal1234]

pleas

Update cell link of radio button, before the relevant table.

please elaborate this solution this would really help me

 

[rupal1234]

How can i open contents like if i select option button 1 then it should open the range from C4:G6
and if i select option button 2 then it should open the range from C9:G11

I don't understand what you mea by open 1.5/ open 2.5

Open what?

 

[bosco_yip]

How can i open contents like

if i select option button 1 then it should open the range from C4:G6

and if i select option button 2 then it should open the range from C9:G11

1] Check if this is what you want.

2] See attached file.

3] The effect is done by Conditional Formatting, please check rule to use.

Regards
Bosco

 

[rupal1234]

1] Check if this is what you want.

2] See attached file.

3] The effect is done by Conditional Formatting, please check rule to use.

Regards
Bosco

my workbook is not working please check if am doing something wrong in my workbook

 

[bosco_yip]

1] Select C4:G6

>> Conditional Formatting >>

>> Choose "Use a formula" …..>> edit the rule box , enter : $M$5=2

>> Click "Format…"

then,

>> select "Fill" tag >> in "Background color", click: "No color"

>> select "Border" tag >> in "Line Style", click: "None" and in "Presets", click "Outline"

>> select "Font" tag >> in "Color", click dropdown button, and click: "White color"

>> OK >> OK >> Finish

2] Select C9:G11

>> Conditional Formatting >>

>> Choose "Use a formula" …..>> edit the rule box , enter : $M$5=1

>> Click "Format…"

then,

Same procedure as above [1].................

3] See attached file, and click the radio button to test.

Regards
Bosco

 

[rupal1234]

View attachment 56212

View attachment 56213

1]Select C4:G6

>> Conditional Formatting >>

>> Use a formula ….., edit the rule , enter : $M$5=2

>> Click "Format…"

then,

>> select "Fill" tag >> in "Background color", click: "No color"

>> select "Border" tag >> in "Line Style", click: "None" and in "Presets", click "Outline"

>> select "Font" tag >> in "Color", click dropdown button, and click: "White color"

>> OK >> OK >> Finish

2] Select C9:G11

>> Conditional Formatting >>

>> Use a formula ….., edit the rule , enter : $M$5=1

>> Click "Format…"

then,

Same procedure as above [1].................

3] See attached file, and click the radio button to check.

Regards
Bosco

Thank you so much for this brief description . Now its working