Adding color to cell

Closed
Report
-
 chessy12 -
Hello,

I want, for example cell A1 to turn red if there is an entry put in cell C1

2 replies

Posts
233
Registration date
Tuesday November 18, 2008
Status
Member
Last seen
August 1, 2010
31
From my experience of excel, i have never saw a formula doing this :s
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

Hi

You could use conditional formatting: highlight cell A1 Select format>conditional formatting>
use the drop down to select formula is and enter =(C1>0) then select the format option and patterns and red. Click OK all way through. When any data is entered in Cell C1 Cell A1 should turn the color you selected.

Should work