PDA

View Full Version : Automatic Conditional Highlighting Column



jcas
08-01-2011, 08:34 AM
Hello everyone:

Im working on a timeline that will represent the start and end date for each task. I need a way of automatically highlighting the entire column when the Actual Week number equals the week number in the timeline. This is to have a better idea on where we are in the timeline.

Please see the attached picture for a better idea.

Thanks for the help.

Bob Phillips
08-01-2011, 11:03 AM
I can't see where the task dates are but you can use a CF such as

=AND(WEEKNUM($C7)<=E$5,WEEKNUM($D7)>=E$5)