Excel 2007 Tab Color with conditional formatting
Looking for someone to help me out. I need a code so that when conditions are met, the tab's color will change.
Conditions...
1. If Value is greater than 1000 then no color
2. If Value is between 1000-100 then Yellow
3. If Value is less than 100 then Red.
Thank you for your time.
see here Palmetto's code
http://www.excelforum.com/excel-prog...ell-value.html
just try it..
Please Login or Register to view this content.
edit: wrong reply! sorry, you asked conditional formatting
Last edited by john55; 02-01-2012 at 11:44 PM.
Regards, John55
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
...enjoy -funny parrots-
Conditional Formatting doesn't apply to sheet tabs, only to cells. You would need to use the Workbook_SheetChange event in the ThisWorkbook module to test if a specific cell (or possibly any cell in a range of cells) has a value that meets your criteria. If it only applies to one worksheet in the workbook (not any/every worksheet), you could just use the Worksheet_Change event in that specific sheet's code module.
I have a similar question as the one asked by Superman07, however, mine is a little bit different. I am building a spreadsheet workbook that contains multiple tabs to calculate the price of Oil, Gas, and Condensate, however, I would like certain tabs within this workbook to change to a specific color based on whether I enter Oil, Gas, or Condensate into a specific cell. For example, if I type the word Oil into cell B6 I would like tabs 1,4,8 to turn blue, but if I type Gas into cell B6 tabs 2,5,9 turn green, and for Condensate tabs 3,6,7 turn yellow. Any help would be greatly appreciated.
COMM2N,
Welcome to the forum.
Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks