Need Conditional Formating help.
 

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.

--
Jon Robershaw
Wardell Builders, Inc

Need Conditional Formating help.
 

Formula is

=FIND("a",a1)0

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"JonWardellBuilders" wrote in
message ...
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.

--
Jon Robershaw
Wardell Builders, Inc

Need Conditional Formating help.
 

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"JonWardellBuilders" wrote in
message ...
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.

--
Jon Robershaw
Wardell Builders, Inc