Format column heading cells in template?
David,
Select all of the heading cells (row 1 I assume) In CF, set Condition1 to FormulaIs Add a formula of =A1<"" (that's 2 double quotes) Select Format button , set Font and Patern as desired exit out -- HTH Bob Phillips "David" wrote in message ... I want to create a template with formatted column headers. However, the headers will be blank in the XLT template and will be filled in by the users and I cant forsee how many will be filled in. What I want is any column heading cell that is non-blank in the XLS spreadsheet to be filled with a pattern. Can I do this with conditional formatting? How do I specify the condition? Thanks to whoever answers! |
All times are GMT +1. The time now is 04:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com