Conditonal Format Tab Color Depending On Contents of a Column

[didymus717]

Hoping someone can help me out here. I have a workbook with multiple worksheets and would like the worksheet TAB COLOR to be conditionally formatted due to the contents of the cells in a particular column. (The particular column may be different depending on the worksheet).

For example:
Sheet TestVBA, Cell A1 = DATE, Cells A2-A26 contains dates (the cell may be blank if there is no date entered). The cells have conditional formatting applied to color the cell a specific color depending on the data entered.

• If Blank Cell Color = NONE
• If Cell Value between Today() and Today()-1000 then Cell Color = GREEN
• If Cell Value between Today()-1000 and Today()-1065 then Cell Color = YELLOW
• If Cell Value between Today()-1065 and Today()-1095 then Cell Color = ORANGE
• If Cell Value '<'Today()-1095 then Cell Color = RED

(I had to enter quotes around the LESS THAN symbol to get the rest of the line to appear above. There are no actual quotes in the code.)​

<today()-1095 color="RED<today()-1095" cell="" then=""></today()-1095>​

The worksheet TAB COLOR.

• If A2-A26 are all GREEN then TAB COLOR = GREEN
• If any A2-A26 are YELLOW or ORANGE then TAB COLOR = YELLOW
• If any A2-A26 are RED or BLANK then TAB COLOR = RED

Any and all input will be greatly appreciated.

Gary

 

[Special-K99]

This would have to be done via VBA, is that what you mean by Conditional Formatting ?

 

[didymus717]

Yes, I should have mentioned that I realize it would need to be VBA. The Conditional Formatting works great for the cell coloring for sure. I know a bit about coding but not sure where to start or where to enter the code.

Thanks,

Gary

 

[Special-K99]

Afraid I'm not an expert on VBA.

 

[didymus717]

Special-K99, Thanks anyways.