how do i highlight rows on my spreadsheet

E

ericb

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
 
F

Frank Kabel

Hi
- select for example rows 1:20
- goto 'format - Conditional format'
- enter the following formula
=ISBLANK($D1)
- chhose your format
 
E

ericb

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...
 
Top