CAN I FORMAT A ROW TO IMITATE A CONDITIONAL CELL?

H

Hayley

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.
 
A

Ardus Petus

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

HTH
 
P

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
 
B

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)
 
P

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
 
Top