Populate cells automatically
 

Hi,

I would like to populate 2 cells with the words Sat and Sun respectively if
all weekdays are selected in other cells. What's the best way of doing this?

Example
A1 = Mon
B1 = Tue
C1 = Wed
D1 = Thu
E1 = Fri

If cells A1 to E1 have that combination, then F1 to automatically populate
with Sat and G1 to populate with Sun. If A1 to E1 does not have that
combination, F1 and G1 to remain blank. Is this possible automatically?

Populate cells automatically
 

On 23-Jan-2008, ?B?am9uIGJveQ==?=
wrote:

I would like to populate 2 cells with the words Sat and Sun respectively
if
all weekdays are selected in other cells. What's the best way of doing
this?

Example
A1 = Mon
B1 = Tue
C1 = Wed
D1 = Thu
E1 = Fri

If cells A1 to E1 have that combination, then F1 to automatically populate

with Sat and G1 to populate with Sun. If A1 to E1 does not have that
combination, F1 and G1 to remain blank. Is this possible automatically?

Conditional IF, or a macro, are possible ways.