Related:
- Adding color to cell
- Rj45 color - Guide
- Notepad++ change background color - Guide
- Powertoys color picker - Download - Other
- How to change crosshair color csgo - Guide
- If cell contains text then return value multiple conditions ✓ - Excel Forum
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
