Dec 22 2020 04:24 AM
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
Dec 22 2020 04:41 AM
SolutionYou 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.
Dec 22 2020 01:37 PM
Dec 22 2020 04:41 AM
SolutionYou 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.