Question Locked

Formating an Excel list

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I'm using Excel 2003, I created a list on a separate worksheet, and named the list, then I used Data > validate to apply the list to a series of cells on a separate worksheet.

I want to apply a color to the cells or fonts in my reference list and have that formatting re-appear on the other worksheet, but every time I make formating changes to the reference list, it always reformats to black text and whatever background color I have the worksheet set to. How can I accomplish this?

5 replies

by liame

How about copying the formatted data, and use the paste special function to paste the format only.

by rthomas

Thanks for the reply, but all this does is replace the formatting in my worksheet with the formatting I've applied to the named list worksheet.

by locolobo

If I'm reading this right you want the following result:

You change the format in the reference list and the formatting in the other worksheet changes to match it.

Are these worksheets in the same workbook? Are you using conditional formatting? When you say, "but every time I make formating changes to the reference list, it always reformats to black text..." do you mean the reference changes back? How are you trying to implement the change?

Maybe someone else here knows the answer right off. The only thing I can think of is writing a macro.

by rthomas

Yes the worksheets are in the same workbook,I have two worksheets, a form worksheet and a list worksheet that contains a named list. I tried conditional formating by setting up a format of "equal to" and then using the text of my list as a constant, and this also did not translate into my form.

What happens is that In my formatted worksheet I select Data > Validation and set each cell up as a list and reference the list name on the other worksheet.

What I would like to do is have a different font color or cell color that would change in the list cell depending on your selection. So If I select list option - "One" I have green colored text or cell, if I select list option "Two" I would have a red colored text or cell and so on for each list selection.

This discussion is closed to new replies.