Ask Experts Questions for FREE Help !
Ask
    bhaskar kp's Avatar
    bhaskar kp Posts: 1, Reputation: 1
    New Member
     
    #1

    Oct 9, 2006, 11:36 PM
    Excel: Macro to designate a color based on condition
    I have an Excel which has three column. First has name(which might repeat in the coming cells) ,second has condition and the third has color. I want to count the number of color for a particular condition against each name

    Thanks
    Bhaskar KP
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
     
    #2

    Oct 10, 2006, 05:35 AM
    If you have Access this is easier in Access. If not use the Microsoft Query addin under the Data menu.

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Count in the Report [ 5 Answers ]

Dear... I have aquestion about the report . I give you example . Table: Size Date FCL 1 X 40' 2/6/2006 FCL 2 X 40' 5/6/2006 FCL 3 X 40' 9/6/2006

Macro system [ 2 Answers ]

:confused: what do you think is the most significant macro system in today's family life. (church, Social agencies, health care program, etc)

How to Automate a macro in excel [ 4 Answers ]

A program logs files at random in txt. abc_log.txt (example) When new info. Is added to the txt file,manualy activate macro and it does what it suppose to do, all OK there. Is there a way a macro code or excel, or perhaps a BAT program can be made to simply "detect" when new data is added...


View more questions Search