How can I highlight one cell based off the values of cells in a column in Microsoft365 Excel?

New Contributor



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? 



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. Excel Screenshot. .jpg

2 Replies
best response confirmed by Alex_C530 (New Contributor)


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




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!