conditional formating on rows & cols depending on one cell

B

bandy2000

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

Thanks
 
B

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