How can Iextend a cell conditional formating to an entire line ?

L

Luc Bongoy

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
 
D

David Biddulph

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
 
M

Max

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
 
Top