Need Conditional Formating help.

  • Thread starter Thread starter JonWardellBuilders
  • Start date 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.
 
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
 
Back
Top