Changing cell color based on value

**smraines** · 12-30-2009, 06:34 PM

Quick question, I know how to change a cells background / text color based on it's own value using conditional formatting but what would be the formula to change cell A1's background color based on the value of cell C1?

Thanks Guys,

Steve

**teylyn** · 12-30-2009, 06:47 PM

Hi,

use conditional format with Formula Is on A1 and use the formula

=C1="whatever"

**smraines** · 12-30-2009, 07:00 PM

Im trying it but it's not working. There is no change at all.

**Palmetto** · 12-30-2009, 07:00 PM

Here is a helpful link to explain CF in a bit more detail.
Conditional Formatting Based on another cell

**smraines** · 12-30-2009, 07:03 PM

Thank You. I appreciate it very much.

**smraines** · 12-30-2009, 07:28 PM

Wow. That was pretty easy now that I seen it. I had been doing it the right way without the absolute reference and thats why it wasnt working. Once I put it in it worked just fine.

Thank again guys,

Steve

**Palmetto** · 12-30-2009, 07:39 PM

Glad you found your solution.

Please mark your thread as solved by going to the top of YOUR first post and clicking on Thread Tools, then Go Advanced.

Don't forget to leave feed back and add to the reputations of all who contributed a helpful response. See my signature for how to go about it.