highlight cell as answer
 

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

highlight cell as answer
 

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/

highlight cell as answer
 

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/