Previous Topic Next Topic

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 Contributor 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

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor 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

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses
Excel function question
1234ah -
ac3mark -

3 responses
Ig stories from close friends to public
Darren -
zara -

31 responses