CAN I FORMAT A ROW TO IMITATE A CONDITIONAL CELL?

[Guest]

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.

 

[Ardus Petus]

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

HTH

 

[Pete_UK]

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

 

[Bob Phillips]

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)

 

[Pete_UK]

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