Same Ref cell return diff values

[Martindelica]

hi there 1 sheet. In cell A2 I want to enter a day of the week and have other cells use that as a reference to return data to its cell. E.,g

Please Login or Register  to view this content.

The day Tuesday has a differnent set of colors for 1, 2 and 3.

[starguy]

hi there 1 sheet. In cell A2 I want to enter a day of the week and have other cells use that as a reference to return data to its cell. E.,g

Please Login or Register  to view this content.

The day Tuesday has a differnent set of colors for 1, 2 and 3.

select cell in col B and go to Format > Conditional format
and set options as follows
Formula is: $A$1="Monday" and choose Red colour from Format tab
add>>
Formula is: $A$1="Tuesday" and choose other colour from Format tab

select cell in column C and in cond. format set:
Formula is: $A$1="Monday" and choose Blue colour from Format tab
add>>
Formula is: $A$1="Tuesday" and choose other colour from Format tab

in the same way apply cond. format for cell in col C

[Martindelica]

I will try but looking at your post my sheet might look messy with colored cells all over the place. I hope I can do what you said, but have it return the text. will it work the same for text?

[starguy]

I will try but looking at your post my sheet might look messy with colored cells all over the place. I hope I can do what you said, but have it return the text. will it work the same for text?

this is what you asked for. obviously each cell will have a colour according to the day mentioned.

[Martindelica]

Sorry for the misunderstanding. I should have stated NOT to return the color as opposed to the text. Is there a formula that will return the text as in the example?

Thanks.

[starguy]

Sorry for the misunderstanding. I should have stated NOT to return the color as opposed to the text. Is there a formula that will return the text as in the example?

Thanks.

in B1

=if(A1="Monday","Red",if(A1="Tuesday","other",""))

same function in C1 but with following change

=if(A1="Monday","Blue",if(A1="Tuesday","other",""))

in D1

=if(A1="Monday","Yellow",if(A1="Tuesday","other",""))

replace the text "other" with colour name for Tuesday

[Martindelica]

Thanks much. WORKED.

[starguy]

Thanks much. WORKED.

you're welcome.

[BigBas]

If you dont want to use if statements, you can set up a table on a different page. Then setup a lookup on an entry page.

See attached.

[Martindelica]

Very educational, I will definitely use this formula in the future once I have familiarized myself more with the functions. Thanks for the input.