| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation - Cell Colour
Hi All,
I am creating a "Data Validation" on "Sheet 1". The Data for the drop down list is on "Sheet 2" e.g. "YES", "NO". I have created the drop down list which gives me the drop down "YES" & "NO" on Sheet 1. My iquiry is, when I select "YES" on the drop down list it places "YES" in the cell. I also want the "cell fill colour" to change to "GREEN". Also when I select "NO" I want the the "cell fill colour" to change to "RED". Can anyone help me? -- ray963 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
| Formatting Data in cell in colour | Excel Discussion (Misc queries) | |||
| can the fill colour of a bar be tied to the data font colour data | Charts and Charting in Excel | |||
| How do I choose a cell colour, without it being tied to the data? | Excel Discussion (Misc queries) | |||
| How to enter a colour in a cell & not data ? | Excel Discussion (Misc queries) | |||
Threaded Mode
