Forum Discussion
Ribbon button wanted to apply custom conditional formatting
- Rather than a CF rule, you could just apply the cell format [>=990000000]0000000000;# to achieve this. You could make this a Cell Style for easy application.
Hi Savia,
Thank you!!! The info on the custom number format is exactly what I needed. I wasn't able to use Cell Styles since Cell Styles are stored per workbook. I was able to add the Cell Style to my personal workbook template, and it works great for all newly-created workbooks, but the data I manipulate is generated from our enterprise application and emailed to me in a spreadsheet, so these spreadsheets do not have the custom Cell Style available and I do not want the extra step of copying the Cell Style from another workbook for each workbook I need to manipulate. However, I easily created a macro in my PERSONAL.XLSB which simply changes the number format to what you gave. I then added the macro to my custom Ribbon tab. Thank you again - this is awesome and will save so much time for me!!!