Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CAN I FORMAT A ROW TO IMITATE A CONDITIONAL CELL?
Select the whole row, and apply the same conditional formatting as your
column HTH -- AP "Hayley" a écrit dans le message de news: ... 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CAN I FORMAT A ROW TO IMITATE A CONDITIONAL CELL?
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: $A10 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CAN I FORMAT A ROW TO IMITATE A CONDITIONAL CELL?
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" wrote in message ... 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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CAN I FORMAT A ROW TO IMITATE A CONDITIONAL CELL?
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional cell format | Excel Discussion (Misc queries) | |||
Conditional Format to highlight blank cell | Excel Worksheet Functions | |||
Office2000: Conditional format behaves strangely | Excel Discussion (Misc queries) | |||
can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) | |||
Can I create a conditional format in a cell using a value from an. | Excel Discussion (Misc queries) |