Conditional formats

[Jamie Hughes]

I've setup a spreadsheet to show me what jobs I need to
complete. Against each job I've done an IF formula that
either returns Outstanding or Complete in a cell
depending on the date.

I've set conditional formatting to highlight the cell if
the job is outstanding, but want to extend the
highlighting across the entire row to highlight all the
job details.

Does anyone know of a way to do this? At the moment I
can only get it to highlight a specific cell. I'm using
Excel 2002 if that helps.

Thanks


Jamie

 

[Frank Kabel]

Hi
if column A (e.g. cell A1) stores your value like 'Outstanding' and you
want to highlight the columns A:F try the following:
- select cells A1:F1
- goto the conditional format dialog and enter the formula
=$A1="Outstanding"
- choose your format