Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can Iextend a cell conditional formating to an entire line ?
Hello all,
I would like to have my conditional formatting applyed from one cell to all the cells of my worksheet which are one the same line or to a range of horizontal line, How can I do that? Tks for your quick answer |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can Iextend a cell conditional formating to an entire line ?
Use "Formula Is", rather than "Cell Value Is".
If you wish all cells in the row to be affected by the formatting based on the value of one cell in that row, then in the conditioning formatting formula use absolute addressing for the column and relative addressing for the row, e.g. =$A1=99 -- David Biddulph "Luc Bongoy" <Luc wrote in message ... Hello all, I would like to have my conditional formatting applyed from one cell to all the cells of my worksheet which are one the same line or to a range of horizontal line, How can I do that? Tks for your quick answer |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can Iextend a cell conditional formating to an entire line ?
The key lies in freezing the column part of the cell ref with the "$" sign in
the CF. Suppose you want to conditionally format the whole row within the range B2:E5 based on values in B2:B5 which are equal to 9 Select B2:E5 (B2 active), then apply CF using Formula is: =$B2=9 Format as desired, ok out If say, B3 = 9, then the row B3:E3 would be conditionally formatted -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Luc Bongoy" wrote: Hello all, I would like to have my conditional formatting applyed from one cell to all the cells of my worksheet which are one the same line or to a range of horizontal line, How can I do that? Tks for your quick answer |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formating - dragging a cond. format over an entire col | Excel Worksheet Functions | |||
Conditional Formating based on data in an entire row | Setting up and Configuration of Excel | |||
conditional cell formating | Excel Discussion (Misc queries) | |||
Help using Conditional Formating of Entire Rows | Excel Worksheet Functions | |||
How to change an entire row using conditional formating | Excel Discussion (Misc queries) |