Keith,

I'm not entirely sure what you question is, but if you are
talking about Conditional Formatting, you can change "Cell Value
Is" to "Formula Is" and enter a formula. If the formula returns a
non-zero numeric result, the format will be applied.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"keith24 " wrote in
message ...
I want to highlight a cell as an answer to an argument rather
than a
value. Any ideas how this can be done?


---
Message posted from http://www.ExcelForum.com/