Cell colors

  • Thread starter Thread starter srain001
  • Start date Start date
S

srain001

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
 
Use Conditional Formatting from the Format menu.

Select D1.
Goto Format->Conditional Formatting

Select Formula Is
Then enter this: =A1="Collateral"

HTH,
Paul
 
Additional note. Don't forget to set the format options. Use the Pattern
tab to set the cell color.

--
 
Hi,

Go to D1 Format Conditional Formatting
Formula Is
=A1="Collateral"
Format Pattern Red ...

HTH
 
Back
Top