Formula to highlight cell based on data value over 2 cells
Closed
insight1979
Posts
1
Registration date
Wednesday December 11, 2013
Status
Member
Last seen
December 11, 2013
-
Dec 11, 2013 at 04:00 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Dec 19, 2013 at 11:12 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Dec 19, 2013 at 11:12 AM
Hi Guys and Girls,
I'm am trying to improve a current spreadsheet I'm using where I am collating movement times in and out of a location.
I want to highlight a single cell (cell A) when it has data input, then when data is entered in to a second cell (cell B) I want cell A to return to being in its normal unhighlighted state.
Any help you can provide would be appreciated.
I'm am trying to improve a current spreadsheet I'm using where I am collating movement times in and out of a location.
I want to highlight a single cell (cell A) when it has data input, then when data is entered in to a second cell (cell B) I want cell A to return to being in its normal unhighlighted state.
Any help you can provide would be appreciated.
Related:
- Formula to highlight cell based on data value over 2 cells
- Tentacle locker 2 - Download - Adult games
- Feeding frenzy 2 download - Download - Arcade
- Fnia 2 - Download - Adult games
- My cute roommate 2 - Download - Adult games
- Resident evil 2 remake free download - Download - Horror
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Dec 19, 2013 at 11:12 AM
Dec 19, 2013 at 11:12 AM
Hi Insight,
Use this formula when applying conditional format:
=AND(A1<>"",B1="")
Best regards,
Trowa
Use this formula when applying conditional format:
=AND(A1<>"",B1="")
Best regards,
Trowa