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

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Dec 19, 2013 at 11:12 AM
Hi Insight,

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

Best regards,
Trowa
0

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
Excel - IF function with multiple words
Nick -
user -

14 responses
If cell = date return yes or no.
JD -
ndwebb -

5 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response