MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Conditional formatting


Posted by Mike on October 31, 2001 7:14 AM

How do you conditional format text data to be "Bold and Italic" in a paticular column? Thank you in advance for any help.

Mike


Posted by Bill Robbins on October 31, 2001 7:18 AM

What is the condition under which the text data is changed to "Bold and Italic" ? I could possibly write the formula for you if I understood under what conditions the text was to appear as "bold and italic".

Bill.

Posted by Mike on October 31, 2001 7:32 AM

If data is text vs. number. Cells with numbers would not change...

Thanks for the help.

Mike

Posted by Barrie Davidson on October 31, 2001 8:21 AM

Use the following formula for your conditional formula (for cell A1).

=ISTEXT(A1)

Then set your formatting.

Regards,
BarrieBarrie Davidson

Posted by Mike on October 31, 2001 10:10 AM

Almost there ... the conditional format would be for a column ...
Thanks again.

Mike

Posted by Barrie Davidson on October 31, 2001 10:15 AM

Conditionally format a cell in the column, copy that cell, select the entire column and then PasteSpecial Formats only.

Regards,
BarrieBarrie Davidson