| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
colour text in validation lists
Hi, I have a number of columns where all cells have a simple validation list (YES,NO). What I would like to do is have a code whereby I can colour a particular response when it is entered. i.e. YES colour = Green. NO colour = Red. This will allow me to quickly scan for any highlights.....anyone have any solutions? thanks, Dario :) -- Dario ------------------------------------------------------------------------ Dario's Profile: http://www.excelforum.com/member.php...o&userid=24597 View this thread: http://www.excelforum.com/showthread...hreadid=381872 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
colour text in validation lists
Select all the cells you want this feature for. Go to Format Conditional Formatting. Add your conditions, something like if select equal to, enter "Yes" i box, click on format button to select a color, either for the cell, o the font. Add another for No. Manges -- mangesh_yada ----------------------------------------------------------------------- mangesh_yadav's Profile: http://www.excelforum.com/member.php...fo&userid=1047 View this thread: http://www.excelforum.com/showthread.php?threadid=38187 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation - Cell Colour | Excel Discussion (Misc queries) | |||
| How to clear validation lists based on other validation lists | Excel Discussion (Misc queries) | |||
| Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
| Validation - Drop Down Lists with tiny text | Excel Discussion (Misc queries) | |||
| Text in Blue colour, but print in black colour | Excel Worksheet Functions | |||
![Dario[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
