Hi
I have used conditional formatting based on cell values – beginning with a specific text, was working OK until I have added other formulas in other cells.
I have attached an example which shows the kind of formulas I have used. Please note, conditional formatting changes when saved and re-opened – hope someone can help
Thanks!
Last edited by sgp; 01-19-2012 at 06:57 AM.
Do you need solution in XL2003 (as example implify) or XL2007 and newer (as your profile say).
Because in 2003 you can have only 3 CF criteras (+ one default color). Or VBA must be involved.
I am working in Excel 2010
Create CF for each criteria:
Thanks - Just what I needed!!!!
Will mark as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks