| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
cell color
is it possible to auto change cell color depending whether there is a yes or
no in the cell...i want to make the cell turn red when i enter yes cheers Keith |
|
#2
|
|||
|
|||
|
read about Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm =LEFT(A1)="y" or if spelled out =A1="yes" --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "kd" wrote in message ... is it possible to auto change cell color depending whether there is a yes or no in the cell...i want to make the cell turn red when i enter yes cheers Keith |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| The color in excel does not show up in the cell on screen | Excel Discussion (Misc queries) | |||
| excel: How can I color code rows based on a value in a cell? | Excel Discussion (Misc queries) | |||
| How do I connect cell color to bar chart color? | Charts and Charting in Excel | |||
| Current Cell Color | Excel Worksheet Functions | |||
| color formating ontingenton upon another cell? | Excel Discussion (Misc queries) | |||
Linear Mode
