Formula to highlight cell based on data value over 2 cells

Closed

insight1979 Posts 1 Registration date Wednesday 11 December 2013 Status Member Last seen 11 December 2013 - 11 Dec 2013 à 04:00
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 19 Dec 2013 à 11:12

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.

Based on the values in cells b77 b81
Based on the values in cells b77 - Excel Forum
Based on the values in cells b77 b88 ✓ - Excel Forum
Code to move rows into another sheet based on certain values ✓ - Excel Forum
How do I get a value in a cell based on another cell - Excel Forum
Based on the values in cells b77:b81, which function can automatically return the value in cell c77? ✓ - Excel Forum

1 response

Réponse 1 / 1

TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
19 Dec 2013 à 11:12

Hi Insight,

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

Best regards,
Trowa

Similar discussions

help me to add particular cells

Fill adjacent cell with number from text answer

Excel function question

Clear cell contents based on value of another cell range using VBA

Conditional formatting cells A and B based on value in C

Similar discussions

Subscribe To Our Newsletter!