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.
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.
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
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks