Conditional formating

[doriainsd]

Thank you in advance for your help. I am new here.

I have created a grid view of a schedule to make it easier for people at a trade show. I have a tab for each demo station/conference room with the data to be collected and a status field.

Demo Station/Conf Room Sheets

Date	Time	Room	Who is scheduling	Sales Rep	Client	Others Needed	Topic	Status
13-Apr	11:00 AM	DS #1	Joe	Jane	ABC	Chris	Baking	Completed
13-Apr	11:30 AM	DS #1
13-Apr	12:00 PM	DS #1
13-Apr	12:30 PM	DS #1
13-Apr	1:00 PM	DS #1

<colgroup><col><col><col><col span="5"><col></colgroup><tbody>
</tbody>

Grid View: I also have a tab for each day at the trade show that will show at a glance all of the demo stations/rooms at a specific time.

	DS #1	DS #2	DS #3	DS #4	DS #5	DS #6	DS #7	DS #8	LG CONF	SM CONF	VHQ
11:00 AM	Who: Joe	Who:	Who:	Who:	Who:	Who:	Who:	Who:	Who:	Who:	Who:
For: Jane	For:	For:	For:	For:	For:	For:	For:	For:	For:	For:
Client: ABC	Client:	Client:	Client:	Client:	Client:	Client:	Client:	Client:	Client:	Client:
Others: Chris	Others:	Others:	Others:	Others:	Others:	Others:	Others:	Others:	Others:	Others:
Subj: Baking	Subj:	Subj:	Subj:	Subj:	Subj:	Subj:	Subj:	Subj:	Subj:	Subj:
11:30 AM	Who:	Who:	Who:	Who:	Who:	Who:	Who:	Who:	Who:	Who:	Who:
For:	For:	For:	For:	For:	For:	For:	For:	For:	For:	For:
Client:	Client:	Client:	Client:	Client:	Client:	Client:	Client:	Client:	Client:	Client:
Others:	Others:	Others:	Others:	Others:	Others:	Others:	Others:	Others:	Others:	Others:
Subj:	Subj:	Subj:	Subj:	Subj:	Subj:	Subj:	Subj:	Subj:	Subj:	Subj:
12:00 PM	Who:	Who:	Who:	Who:	Who:	Who:	Who:	Who:	Who:	Who:	Who:
For:	For:	For:	For:	For:	For:	For:	For:	For:	For:	For:
Client:	Client:	Client:	Client:	Client:	Client:	Client:	Client:	Client:	Client:	Client:
Others:	Others:	Others:	Others:	Others:	Others:	Others:	Others:	Others:	Others:	Others:
Subj:	Subj:	Subj:	Subj:	Subj:	Subj:	Subj:	Subj:	Subj:	Subj:	Subj:

<colgroup><col><col span="11"></colgroup><tbody>
</tbody>

What I would like to do is when the meeting is set to complete on the room tabs is to have the cells on the day/grid view for that time turn Red Yellow or green based on the status field on the room.

	DS #1
11:00 AM	Who: Joe
For: Colette
Client: Stanford
Others: Chris
Subj: Outcomes

<colgroup><col><col></colgroup><tbody>
</tbody>

Hope that makes sense. Thanks in advance for your help!

D

 

[gebobs]

So regardless of the current time and the schedule, nothing happens until the room's status is marked complete?

Are the data in the Room tabs generated automatically via the Day tabs or vice versa?

This seems like a monumental project.

 

[doriainsd]

So regardless of the current time and the schedule, nothing happens until the room's status is marked complete?

Are the data in the Room tabs generated automatically via the Day tabs or vice versa?

This seems like a monumental project.

The Day tabs are populated from the room tabs. And yes, nothing happens until complete is marked. The status is actually 3 values Completed, No-Show, and Rescheduled). In the end I would want Green=Completed, No-SHow=Red, and Rescheduled=Yellow.

Thanks again!

 

[gebobs]

The Day tabs are populated from the room tabs.

How do you go about doing that out of curiosity?

 

[doriainsd]

How do you go about doing that out of curiosity?

It's done with formulas linking to the data.

 

[gebobs]

Let me ponder this.