You just reference the cell with the data in the formula. For instance in B1
you could use

=A1=10

and it returns a TRUE or FALSE that CF works on.


--
HTH

Bob Phillips

wrote in message
oups.com...
unfortunately no...

I have ascii data that gets parsed and brought into Excel. Now I need
to analyze the data, so if I write a formula, it can't be in the same
cell as the results and I can't have extra cells... that's why i was
thinking macro... so something could run in the background and color
the cells with the raw data without creating cells with formulas.