| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell colors
Hi,
I'm looking for a way to change the color of one cell when a specific value in another is entered. For example, if A1 is equal to "Collateral", I would like D1 to become RED. Help please! Thanx! Srain |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell colors
Use Conditional Formatting from the Format menu.
Select D1. Goto Format-Conditional Formatting Select Formula Is Then enter this: =A1="Collateral" HTH, Paul -- "srain001" wrote in message ... Hi, I'm looking for a way to change the color of one cell when a specific value in another is entered. For example, if A1 is equal to "Collateral", I would like D1 to become RED. Help please! Thanx! Srain |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell colors
Additional note. Don't forget to set the format options. Use the Pattern
tab to set the cell color. -- "PCLIVE" wrote in message ... Use Conditional Formatting from the Format menu. Select D1. Goto Format-Conditional Formatting Select Formula Is Then enter this: =A1="Collateral" HTH, Paul -- "srain001" wrote in message ... Hi, I'm looking for a way to change the color of one cell when a specific value in another is entered. For example, if A1 is equal to "Collateral", I would like D1 to become RED. Help please! Thanx! Srain |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell colors
Hi,
Go to D1 Format Conditional Formatting Formula Is =A1="Collateral" Format Pattern Red ... HTH |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell colors
See also your other post about a pop-up message.
Gord Dibben MS Excel MVP On Fri, 14 Dec 2007 07:07:03 -0800, srain001 wrote: Hi, I'm looking for a way to change the color of one cell when a specific value in another is entered. For example, if A1 is equal to "Collateral", I would like D1 to become RED. Help please! Thanx! Srain |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| if one cell greater than another cell, how to change colors? | Excel Discussion (Misc queries) | |||
| Lost highlighting and font colors; background colors on web pages | Excel Discussion (Misc queries) | |||
| Cell colors or text color changing when date in cell gets closer. | Excel Worksheet Functions | |||
| Cell colors | Excel Discussion (Misc queries) | |||
| Can't format font colors or cell fill-in colors | Excel Discussion (Misc queries) | |||
Linear Mode
