Thread
:
Need a shaded row in Excel that doesn't move as data changes
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Ken Johnson
Posts: n/a
Need a shaded row in Excel that doesn't move as data changes
You could use conditional formatting.
If row 10 is to be shaded select the row 10 cells, then in the Formula
Is box of the conditional formatting dialog use...
=ROW()=10
Ken Johnson
Reply With Quote
Need a shaded row in Excel that doesn't move as data changes