conditional formatting

[MEL79]

is it possible to do conditional formatting for an entire row but using the information for a specific cell/column? I want the entire row to change colour when the information in one column is between certain values. Another related question is that I'm counting the # days between a start and end date but I want it to stop when i enter a received in another column, how can i do that?

[dns22]

With regards to your first question, yes it is possible. i've done it the following way:
1) Select the cells in the row that you want to change color. in my case, the cell that would determine the color was the last cell in the row. not sure if that matters.
2) Go to Format\Conditional Formatting
3) Choose "Formula Is" under Condition 1. Then use the following formula, changing cell number and values as appropriate for your spreadsheet: =AND($E2>100,$E2<250)
where E2 is the cell that determines the color.
4) Choose the Format that you want.

You'll notice above in step 3) that only the E is hardcoded ($E). To apply the conditional formatting to other rows of data, you can use Copy \ Paste Special \ Formats.
Hope this helps

[MEL79]

It does help thanks ...