SOLVED

Highlighting Cells

Copper Contributor

Good Morning, 

 

I did a search and couldn't find the answer to my questions. I'm looking to highlight a Cell (for example H4) when any text is inserted into other cells in the row. (B4:G4) Is this something that can be done?

 

Thank you in advance

 

Dafydd

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

@DafHumph 

You can use conditional formatting for this.

Let's say you want to do this for rows 4 through 20.

Select H4:H20. I will assume that H4 is the active cell in the selection,

On the Home tab of the ribbon, select Conditional formatting > New Rule...

Select 'Use a formula to determine which cells to format'.

Enter the formula

 

=COUNTA(B4:G4)>0

 

(If the active cell is not in row 4, adjust the formula accordingly).

Click Format...

Activate the Fill tab.

Select a highlight color.

Click OK, then click OK again.

@Hans Vogelaar 

 

This is exactly what I was after. Thank you so much

1 best response

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

@DafHumph 

You can use conditional formatting for this.

Let's say you want to do this for rows 4 through 20.

Select H4:H20. I will assume that H4 is the active cell in the selection,

On the Home tab of the ribbon, select Conditional formatting > New Rule...

Select 'Use a formula to determine which cells to format'.

Enter the formula

 

=COUNTA(B4:G4)>0

 

(If the active cell is not in row 4, adjust the formula accordingly).

Click Format...

Activate the Fill tab.

Select a highlight color.

Click OK, then click OK again.

View solution in original post