Conditional Formatting

[General Specific]

Can conditional formatting check cell A1 for a number greater than one
and change the color of the font for the cells B1 through G1 if true?

I basically want to hide row contents (font white against white) until
the first cell is filled.

Is this possible?

 

[Dave Peterson]

Select B1:G1 (or B1:Gxx if you want to do multiple rows at once).

Then with the activcell in row 1:
format|Conditional formatting|Formula is: =$A1=""
The $A means to always look at the value in column A.

give it a nice white font.

 

[Bob Phillips]

Sure.

Select B1:G1

Goto CF
Change Condition 1 to Formula Is
Add a formula of =$A1>1
and format as required

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[L. Howard Kittle]

Select the cells and under conditional format > formula is > "=a1>0" >
format > font > set color. No " " in formula.

HTH
Regards,
Howard