LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 95
Default Worksheet tabs to turn colors against criteria

I want my sheet tabs to change color depending on the date. on the sheet

Example, each sheet represents a customer when the customer is yup for
renewal in less than 90 days to turn red, between 91 and 180 days turn orange
and beyond 180 days to turn green.

Can someone help me with this?

Neall

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Worksheet formatting (fill colors & text colors) disappeared sweettooth Excel Discussion (Misc queries) 2 June 24th 08 01:16 AM
Cells turn colors if greater than specified values or pop up remin hmsawyer Excel Discussion (Misc queries) 3 March 24th 08 01:59 PM
how do I turn on the tabs? Devonshire Excel Discussion (Misc queries) 4 March 18th 08 03:39 PM
How do you change the colors of lower Label Tabs in a worksheet? Edgar[_2_] Excel Discussion (Misc queries) 3 August 2nd 07 11:39 PM
Apply Colors to Worksheet Tabs Ro Excel Worksheet Functions 1 November 15th 06 07:03 PM


All times are GMT +1. The time now is 01:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"