Related:
- Adding color to cell
- Excel cell color formula - Guide
- Color 65535 - Guide
- Powertoys color picker download - Download - Other
- Sound card color code - Guide
- Rj45 color code - Guide
2 responses
sarbel.vilo
Posts
233
Registration date
Tuesday November 18, 2008
Status
Member
Last seen
August 1, 2010
31
Nov 24, 2009 at 11:03 AM
Nov 24, 2009 at 11:03 AM
From my experience of excel, i have never saw a formula doing this :s
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
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
