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 add, but I can't seem to add the proper rule or find any information regarding this subject. Can anyone please assist me with my dilemma?
Example:
In the screenshot I provided, H2 (Event 5) header cell would also get highlighted whenever there's any data entered in column H, rows H3 and below. Basically indicating/highlighting that H2 header has data in that column. I would then like to apply this rule to each header cell / column.
Thank You,
Alex C.
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!
