highlight cell as answer

  • Thread starter Thread starter keith24
  • Start date Start date
K

keith24

I want to highlight a cell as an answer to an argument rather than
value. Any ideas how this can be done
 
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
 
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
 
Back
Top