conditional formats based on If

M

Mike

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
 
M

Mike

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
 
B

Biff

Select your range, A229:J423

Goto the menu Format>Conditional Formatting
Formula Is: =$A$1="m"
Click the Format button
Font tab>Color>white
OK out

Biff
 
M

Mike

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
 
B

Biff

Thank you but when you type the formula in it defaults to
that cell that you want to format not the rage selected.
Click to expand...

Not following you on that. The cell(s) that you want to format *ARE* the
cell(s) in the selected range.

Biff
 
D

Don Guillett

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 format>conditional
format>select formula is>type 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.
 
Top