I want to highlight a cell as an answer to an argument rather than
value. Any ideas how this can be done

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

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/

Keith

not sure I really understand your question. However, if you are saying you
want to change the format of one or more cells depending on the value of
another cell, have a look at Formatting | Conditional Formatting...

Regards

Trevor


"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/