Formula to highlight cell based on data value over 2 cells

[Closed]
Report
Posts
1
Registration date
Wednesday December 11, 2013
Status
Member
Last seen
December 11, 2013
-
Posts
2817
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 14, 2021
-
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.

1 reply

Posts
2817
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 14, 2021
486
Hi Insight,

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

Best regards,
Trowa