Conditional Formatting

P

PRS1114

I have a spreadsheet where I log certain tasks to be completed and their due
dates. I would like to set up conditional formatting to fill the entire row
with a gray color once the job have been completed. I have a column that has
a completion date that is filled in by which ever person completed the task.
Is there a way to make the entire row fill once a value has been entered into
one cell and if so, how do I do that? Any help would be appreciated. Thank
you.
 
T

TWhizTom

You do not want to fill an entire row with a color!

That would fill 256 columns with color in 2003 and earlier versions and
16384 columns in version 2007. If user prints, they are going to get a whole
lot of pages with nothing but a colored column/line

Instead, name the range and fill only the range
 
J

Joerg Mochikun

Let's assume your data are in range A2:G10 and the completion dates are
entered in column E.

1) Select range A2:G10
2) From menu select Format => Conditional Formatting
3) For Condition1 select 'Formula is'and type in the formula
"=NOT(ISBLANK($E2))" without the quotes.
4) Set the format for this condition as needed (in your case select a gray
cell shading)
5) Press 'OK'

Now whenever a value is entered into a cell of column E, the whole row (up
to column G) turns gray.

Hope that this is what you want to achieve.

Cheers,

Joerg Mochikun
 

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

Top