Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formating =mod($a2,2) = not(mod($a2,2)) | Excel Worksheet Functions | |||
Conditional Formating | Excel Discussion (Misc queries) | |||
Conditional formating | Excel Discussion (Misc queries) | |||
conditional formating | Excel Worksheet Functions | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) |