conditional format

[kevin carter]

hi
i have a workbook containing columns of data
i want to hide some of the data untill it is required.
when one column has date entered ito it i want to show the next column
i am trying to hide the data with conditional formatting
ie text is white(default)
on a condition turn the text black(over a range (c1:c10)

i have used the countif statement
COUNTIF(A1:A10,"<>")
if the result of this is bigger than 0 then change text colour in column C

Can anyone help please


Thanks in advance


kevin

 

[Frank Kabel]

Hi
not quite sure but try
=COUNTA($A$1:$A$10)=0
and assign the white font color for this condition

 

[kevin carter]

thanks i will give it a try

Hi
not quite sure but try
=COUNTA($A$1:$A$10)=0
and assign the white font color for this condition