Unable to highlight an entire row

Marcy S.

I am unable to highlight a entire row.

 

It appears the box that was lasted edited will not highlight.

 

Also, if I edit a highlighted row the box will turn white.

 

I attempted to use the paint brush to get around this issue and it works sometimes.

 

Kindly let me know if you have any tips pr tricks

Amanda Clark

I am having the same issue and it is very, VERY frustrating.  It seems to bee random - sometimes it will update, other times it won't.  You can log off and come back in and sometimes the colors have updated, sometimes thye have reverted.  

Marcy S.

Hello Amanda,

Thank you for commenting on my post. I found the fix. Click on Highlight Changes and disable.

 

Best,

-m-

JohnHinkle

Good solution, Marcy! Highlight changes will override any other background formatting you have in your sheet (when it is enabled). 

Victor van R

You may also create and additional column and assign in thei column a number or code to the row(s) that you want to highlight. Use conditional formatting to color the row based on the number or code. You can hide the row with the number or code to keep the sheet clean.