How can I use conditional formatting to hide or delete rows?
Making font color same as background "hides" the text on the screen,
but depending on colors chosen (e.g. white on white), it may be visible
when it prints.
Use custom number format of ";;;" to hide text on display and print
Roger Govier wrote:
Hi Linda
Conditional formatting will not hide rows or delete rows.
You could use conditional formatting to make the font colour equal the
background colour, so the data would appear to be "hidden", but the row
will still show.
Why not mark your header row and DataFilterAutofilter
Use the dropdown on column A to select Non Blanks
--
Regards
Roger Govier
"linda.beautiful.california"
. com wrote in message
...
I want to use conditional formatting to hide or delete rows in Excel if
the
cells in column A are blank. How can I do this or, if conditional
formatting
won't work, what other way is there to accomplish this?
|