use the format painter to copy the format
--
Don Guillett
SalesAid Software

"Mike" wrote in message
...
Hi Don

Thanks for replying so quick

But how can I highlight =$A$229:$J$423 as the range where =$A$1="m"

=$A$229:$J$423 is the range i want to format if A1=m

Mike



"Don Guillett" wrote:

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