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
- ADO Recordsets
- Adding a command button to the toolbar or menu bar in Excel?
- Solved access populate combo box help needed
- Backup and Restore Data/Metadata for a Novel Backend.
- [Access SQL]: Have a function similar Oracle SQL function Minus use in MS Access SQL?
- Variable declaration + assignment
- Exporting variables
- checkbox value on Workbook_Open
- Sum of hours using select statement & VBA
- IsError function from VBA6.3 to v6.0
Microsoft ISV
- Call Windows API to store hyperlink path to external documents
- Need help about combo boxes in Visio 2003
- Help with a formula
- String Functions
- How to copy pivot table RESULT from Access to Excel
- send excel 2007 workbook using cdo?
- startup properties in Access
- iexplore.exe - Application Error
- How to use pivot data in function?
- Copy text from textbox to clipboard?
Regarding Conditional Formatting.
junnie
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.
Dean Johnson - MSFT
Hi Derek,
Thank you very much for the reply. It is very helpful for me as of now.
Thanks Again,
Basav