how do i highlight rows on my spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i am currently trying to highlight specific rows of a spreadsheet i am
creating, but would only want the row highlighted if the D column is left
blank. and it should be spreadsheet wide. could you help? thanks
 
Hi
- select for example rows 1:20
- goto 'format - Conditional format'
- enter the following formula
=ISBLANK($D1)
- chhose your format
 
danke schon. you rock. -ericb

Frank Kabel said:
Hi
- select for example rows 1:20
- goto 'format - Conditional format'
- enter the following formula
=ISBLANK($D1)
- chhose your format
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula Help 9
more rows highlight than I want 1
Formula help 3
How do I auto highlight the row and column I'm working on? 2
Shift + Home highlights entire worksheet to top, not single row 2
How can I tell excel to highlight every 4 rows? 4
Excel Typed text appears in wrong cell 0
Highlighting reaccuring info in a spreadsheet 2

Back
Top