Y
Yvonne
I would like to highlight each cell if there is any text E2 through U2; I am
using conditional formatting. (The problem is that I had to select a special
charater in order for the conditional formatting to recognize; ie. =E2>"* ".
Is there a way that it will recognize any type of text w/o being specific?
Once all my cells E2:U2 are highlighted than I would like A1 to say full; I
tryed an if function, however, it was extremely long. Is there a shorter
formula? =IF(AND(E5>"* ",F5>"* ",G5>"* ",H5>"* ",I5>"* ",J5>"* ",K5>"*
",L5>"* ",M5>"* ",N5>"* ",O5>"* ",P5>"* ",Q5>"* ",R5>"* ",S5>"* ",T5>"*
",U5>"* "),"Full","")
Another problem I have not overcome is that if I use Merge Cells in the cell
range e2:u2 than the If Function in A1 doesn't recognize the unused cells.
I appreciate any help. I am so frustrated because this should be rather
simple and I am making it complicated!!! (I am no good at Macros!!! Can I
do this???)
using conditional formatting. (The problem is that I had to select a special
charater in order for the conditional formatting to recognize; ie. =E2>"* ".
Is there a way that it will recognize any type of text w/o being specific?
Once all my cells E2:U2 are highlighted than I would like A1 to say full; I
tryed an if function, however, it was extremely long. Is there a shorter
formula? =IF(AND(E5>"* ",F5>"* ",G5>"* ",H5>"* ",I5>"* ",J5>"* ",K5>"*
",L5>"* ",M5>"* ",N5>"* ",O5>"* ",P5>"* ",Q5>"* ",R5>"* ",S5>"* ",T5>"*
",U5>"* "),"Full","")
Another problem I have not overcome is that if I use Merge Cells in the cell
range e2:u2 than the If Function in A1 doesn't recognize the unused cells.
I appreciate any help. I am so frustrated because this should be rather
simple and I am making it complicated!!! (I am no good at Macros!!! Can I
do this???)