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
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.
Related:

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
Hi Insight,

Use this formula when applying conditional format:
=AND(A1<>"",B1="")

Best regards,
Trowa
0