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
