conditional formats based on If
 

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

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

conditional formats based on If
 

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

conditional formats based on If
 

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

conditional formats based on If
 

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

conditional formats based on If
 

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

conditional formats based on If
 

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

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

Biff

"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

conditional formats based on If
 

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