conditional formating on rows & cols depending on one cell

[bandy2000]

HI,
Is it possible to apply a conditional formating to a complete row or column
depending to one cell?

Thanks

[Bob Phillips]

Yes select the row, and in CF change the condition type to Formula Is, and
use a formula of say

=$A1="value"

assuming it is row 1

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"bandy2000" <[email protected]> wrote in message
news:[email protected]...
> HI,
> Is it possible to apply a conditional formating to a complete row or
column
> depending to one cell?
>
> Thanks