View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default conditional formating on rows & cols depending on one cell

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" wrote in message
...
HI,
Is it possible to apply a conditional formating to a complete row or

column
depending to one cell?

Thanks