Perhaps we didn't understand. You said you wanted all cells font to be white
if a1 =m. To do this, select the cells desired and formatconditional
formatselect formula istype in
=$A$1="m"
EXACTLY as shown, including the $, the a as A and the " " around the m
format as desired.
or, do one and use the format painter. Let's all hope that this time you
understand.

--
Don Guillett
SalesAid Software

"Mike" wrote in message
...
Thank you but when you type the formula in it defaults to that cell that
you
want to format not the rage selected.

Really appreicate your help here.

Mike

"Biff" wrote:

Select your range, A229:J423

Goto the menu FormatConditional Formatting
Formula Is: =$A$1="m"
Click the Format button
Font tabColorwhite
OK out

Biff

"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