If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Drop-Down list
I've created a drop-down list that has the options No and
Yes. Is there any way I can get the No option in my list to be coloured red and the Yes option to be coloured blue? I'm using Excel 2000. |
#2
|
|||
|
|||
Hi
use 'Format - Conditional format' for this AFTER you have inserted in the cell. No chance to color the entries in a drop-down differently -- Regards Frank Kabel Frankfurt, Germany schrieb im Newsbeitrag ... I've created a drop-down list that has the options No and Yes. Is there any way I can get the No option in my list to be coloured red and the Yes option to be coloured blue? I'm using Excel 2000. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Drop Down List / Count Function | Mukiwa | Worksheet Functions | 2 | July 7th, 2004 11:56 PM |
Drop Down Menus | Dude | Worksheet Functions | 1 | June 24th, 2004 12:25 AM |
How to direct user to enter certain cells from drop down list? | courtesio99 | Worksheet Functions | 0 | December 9th, 2003 04:47 AM |