Conditionnal formatting using VB
As you said, conditional formatting only supports 3 formats. If it is numbers, normal formatting can color the font for some additional conditions. Otherwise, you would have to use the Change or calculate events to run code to do the formatting. http://www.cpearson.com/excel/events.htm -- Regards, Tom Ogilvy "Sherif" wrote in message ... I need to apply some conditional formatting to my Sheet, however by using the preset function I can only apply up to 3 different formattings, I need more, how can I do it? |
All times are GMT +1. The time now is 11:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com