SOLVED

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

Copper Contributor

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

2 Replies
best response confirmed by Alex_C530 (Copper Contributor)
Solution

@Alex_C530 

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!
1 best response

Accepted Solutions
best response confirmed by Alex_C530 (Copper Contributor)
Solution

@Alex_C530 

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.

View solution in original post