Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-15-2014, 10:37 AM
alw alw is offline Color Fomatting Windows 7 64bit Color Fomatting Office 2013
Novice
Color Fomatting
 
Join Date: Mar 2014
Posts: 8
alw is on a distinguished road
Default 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
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Color Fomatting 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
Color Fomatting Fill Color curtis.walker@sgmc.org Excel 4 03-15-2013 12:30 PM
Color Fomatting Can't get the same color lostsoul62 Excel 2 06-14-2012 08:32 PM
Color Fomatting Count By Color beb1227 Excel 4 06-15-2011 08:46 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:48 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft