Forum Discussion
Solved
How can I highlight one cell based off the values of cells in a column in Microsoft365 Excel?
Hello, I'm trying to highlight a Header cell whenever there's numerical data entered into any cell below the same header column. It seemed like it would've been an easy conditional formatting ad...
Select (for example) D2:Z2. D2 should be the active cell in the selection.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula=COUNTA(D3:D1000)
Click Format...
Activate the Fill tab.
Select a highlight color.
Click OK, then click OK again.
Select (for example) D2:Z2. D2 should be the active cell in the selection.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
=COUNTA(D3:D1000)
Click Format...
Activate the Fill tab.
Select a highlight color.
Click OK, then click OK again.
- @Han Vogelaar
Awesome, that worked out perfectly! Thank you for your quick response and for all your help!
