Need Conditional Formating help.

  • Thread starter JonWardellBuilders
  • Start date
J

JonWardellBuilders

I have a row in a worksheet that contains a text description of items being
purchased. What i want to do is Format all rows that contain a * to be in
italics.

I don't know how to word it, but i want this condition:

if cell value contains a * i want the cell to be in Italics.

i.e. if cell says "interior wall mount *" i want it to read the same but in
italics.
 
B

Bernard Liengme

Select all the cells to have the conditional format
Use Formula IS; =ISNUMBER(FIND("*",A1))
But change A1 to be the fist cell in your selected range
The click the format button and specify italic font
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top