CAN I FORMAT A ROW TO IMITATE A CONDITIONAL CELL?

One column is subject to conditional formatting, if a cell is positive I need
not only that cell to be reformatted but also all the information entered on
the row.

Select the whole row, and apply the same conditional formatting as your
column

HTH
--
AP

"Hayley" <Hayley@discussions.microsoft.com> a écrit dans le message de news:
F692A69E-33BB-4D22-BB58-F16D91FD5E76@microsoft.com...
> One column is subject to conditional formatting, if a cell is positive I
> need
> not only that cell to be reformatted but also all the information entered
> on
> the row.

Assuming the cell to be tested is A1, then highlight all the cells in
row 1 and click Format | Conditional Formatting. Choose Formula Is
rather than Cell Contents and enter this formula:

$A1>0

then choose what format you want - foreground colour or background
(patterns tab) colour - then OK.

If you want to apply this format to several rows, highlight the same
cells, click Format Painter, then highlight the cells on other rows.

Hope this helps.

Pete

Select the whole row, and in the conditional formatting, use a condition of
Formula Is, and a formula such as

=$D4=condition

Note the$ in the cell reference which fixes the column being tested.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Hayley" <Hayley@discussions.microsoft.com> wrote in message
news:F692A69E-33BB-4D22-BB58-F16D91FD5E76@microsoft.com...
> One column is subject to conditional formatting, if a cell is positive I
need
> not only that cell to be reformatted but also all the information entered
on
> the row.

Just following up on this. Hayley emailed me a copy of her sheet
directly, and I was able to set the CF for her.

Pete