Related:
- Adding color to cell
- Notepad++ background color - Guide
- Sound card color code - Guide
- Rg45 color coding - Guide
- Powertoys color picker download - Download - Other
- Html text color - 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
