SOLVED

Highlighting Cells

%3CLINGO-SUB%20id%3D%22lingo-sub-2009250%22%20slang%3D%22en-US%22%3EHighlighting%20Cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2009250%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20Morning%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20did%20a%20search%20and%20couldn't%20find%20the%20answer%20to%20my%20questions.%20I'm%20looking%20to%20highlight%20a%20Cell%20(for%20example%20H4)%20when%20any%20text%20is%20inserted%20into%20other%20cells%20in%20the%20row.%20(B4%3AG4)%20Is%20this%20something%20that%20can%20be%20done%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDafydd%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2009250%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2009330%22%20slang%3D%22en-US%22%3ERe%3A%20Highlighting%20Cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2009330%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F909336%22%20target%3D%22_blank%22%3E%40DafHumph%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20use%20conditional%20formatting%20for%20this.%3C%2FP%3E%0A%3CP%3ELet's%20say%20you%20want%20to%20do%20this%20for%20rows%204%20through%2020.%3C%2FP%3E%0A%3CP%3ESelect%20H4%3AH20.%20I%20will%20assume%20that%20H4%20is%20the%20active%20cell%20in%20the%20selection%2C%3C%2FP%3E%0A%3CP%3EOn%20the%20Home%20tab%20of%20the%20ribbon%2C%20select%20Conditional%20formatting%20%26gt%3B%20New%20Rule...%3C%2FP%3E%0A%3CP%3ESelect%20'Use%20a%20formula%20to%20determine%20which%20cells%20to%20format'.%3C%2FP%3E%0A%3CP%3EEnter%20the%20formula%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DCOUNTA(B4%3AG4)%26gt%3B0%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E(If%20the%20active%20cell%20is%20not%20in%20row%204%2C%20adjust%20the%20formula%20accordingly).%3C%2FP%3E%0A%3CP%3EClick%20Format...%3C%2FP%3E%0A%3CP%3EActivate%20the%20Fill%20tab.%3C%2FP%3E%0A%3CP%3ESelect%20a%20highlight%20color.%3C%2FP%3E%0A%3CP%3EClick%20OK%2C%20then%20click%20OK%20again.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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 (New 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