Hi All,
I am using Excel in my VBA application. Is there a ristriction of using the Conditional Formatting If yes how many conditions I can use in a WorkBook
Thanks,
Basav
Regarding Conditional Formatting.
Hot Topic
- How to use data from inputbox
- VBA Userform Control of multiple userform controls
- What is the code for closing out an excel file while in the browser?
- Office2003 VBA 6.3 Help files not working correctly.
- Verifying completion of a file's creation from VBA
- SheetFollowHyperlink event
- installling business scorecard manager 2005
- Newbie Help: All caps to Title caps
- Visual Studio Tools for Applications
- 0x62304320 referenced memory at 0x62304320
Microsoft ISV
- worksheet_change and data validation
- Updating a pivot table
- automatical start macro in access2003
- last row
- Is there plug-ins to Live Communication Server 2005 to make it work like a call center?
- Application.FileSearch in Excel 2007
- Bundling OA2007 Express with our product
- last Modified date in Excel spreadsheet
- Dialog Sheet not showing up
- Registration Limits and Useage Rules
Regarding Conditional Formatting.
Laura06
Hi Basav,
Your limited to 3 conditional formats in a work book using Excel's front screen. If your using VBA then you can program unlimited conditional formats by handling the Workbook_SheetChanged event and putting the logic and formatting in there.
nizmo
Hi Derek,
Thank you very much for the reply. It is very helpful for me as of now.
Thanks Again,
Basav