how to get the a conditional value and underline them from a table

[sumesh56]

i want to get a value below 17 from a table and get them underlined in a single step. how can i do this? a sample file is attached.

[etaf]

if you want to underline all values below 17

Highlight A2:E12

and use
A2<17 as a formula
and format as underline

OR you can use
Highlight cells rules
Less
Than
put in 17
choose
custom format
and use underline

[sumesh56]

if you want to underline all values below 17

Highlight A2:E12

and use
A2<17 as a formula
and format as underline

OR you can use
Highlight cells rules
Less
Than
put in 17
choose
custom format
and use underline

thanks for the reply. this is what i wanted .thanks for help.

[sumesh56]

if you want to underline all values below 17

Highlight A2:E12

and use
A2<17 as a formula
and format as underline

OR you can use
Highlight cells rules
Less
Than
put in 17
choose
custom format
and use underline

thanks for the reply.