View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default conditional formats based on If

formatconditional formatformula is
=$A$1="m"
--
Don Guillett
SalesAid Software

"Mike" wrote in message
...
Hi, I have a sheet and I would like to Hide a whole buch of stuff IF a
letter
somehwere else is showing. i.e. if cell a1 = m then b1:G20 font is white
(doesn't show) Thanks very much