Programming Colors

A

Ana Amaya

I have three choices on my spreadsheet Accept, Pend,
Reject. Is there anyway to make exel recognize these
words and automatically put Accept in Green, Pend in
Orange and Reject in Red?
 
T

Trevor Shuttleworth

Ana

you can do this with conditional formatting. Format | Conditional
formatting...

Regards

Trevor
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unclear change tracking process 0
Problem with MS Word paragraph and character styles: format getting messed up 2
Is there any way to reliably override change tracking actions in Word? 1
Multiple IF Statement in Word 5
Word 2003: Want a macro for accept + next change 0
Cobditional Formatting Rows based on dates in action plan. 0
Printing from Word my Inserted Pictures colors are dull and lack color 0
Track Changes 2

Top