#1
|
|||
|
|||
Color Fomatting
I have column A that has values 1-4 in various cells.
I want for examples: whatever cells A3 through A30 = "1" then A3,B3,E3,F3 and I3 turn green Whatever cells A3 through A30 = "2" then A3,B3,E3,F3 and J3 turn blue Whatever cells A3 through A30 = "3" then A3,B3,E3,F3 and K3 turn gold Whatever cells A3 through A30 = "4" then A3,B3,G3 and L3 turn orange color doesn't matter, just need to be different based on numbers 1 through 4 in column A I am trying to highlight cells that will need input based on number in column A. (I am really new to this) Just trying to do material take-offs. I can post a file if needed (if I figure out how) I would also like to know how to download posted excel files if needed Thanks for any input Al Last edited by alw; 03-15-2014 at 10:58 AM. Reason: wanted to attach file |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
I created a custom XML color scheme. How do I add that to the Built-in Color? | Cassik | PowerPoint | 5 | 11-04-2013 02:08 PM |
changing color | aerospace | Outlook | 0 | 04-03-2013 05:56 AM |
Fill Color | curtis.walker@sgmc.org | Excel | 4 | 03-15-2013 12:30 PM |
Can't get the same color | lostsoul62 | Excel | 2 | 06-14-2012 08:32 PM |
Count By Color | beb1227 | Excel | 4 | 06-15-2011 08:46 AM |