The Conditional Formatting has it's own area to be entered.
You can have up to 3 conditional formatting formulas per cell.
http://www.mvps.org/dmcritchie/excel/condfmt.htm

format, conditional formatting
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"thrasher" wrote in message ...
If a cell contains a formula, can you create a conditional format in that
cell based on a condition of another cell that also contains a formula? I
cannot get that to work.