• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Recent content by ananthram

  1. A

    Data validated [SOLVED]

    Yuppie!!~ Bobhc Sir, u made my day this is exactly wat i needed... thanks a lot.
  2. A

    Data validated [SOLVED]

    Ty sir, as u said exactly wat i am expecting too i need like u gave below So if you choose Quality control then you only want to see QC_1 QC_2 QC_3 QC_4 QC_5 QC_6 QC_7 QC_8 in the task sheet? >> Yes, i need like this :)
  3. A

    Data validated [SOLVED]

    sorry but i need those task in data validation. `example: if i select Content reviewer in role it should show only the content reviewer's task in task column with data validation P.S: just like forms which will be in some internet registration page.
  4. A

    Data validated [SOLVED]

    Hi All, i need a help on file which is in below given link. https://app.box.com/s/8muubfilwvmz0fmfx383 When i select data validated value in role column which is in Sheet1 it should only the role related task where the table in SRC sheet. This should be a formula or a macro.
  5. A

    how can i work on percentage's in VBA

    Hi Narayan Sir, this is exactly what i need but how can i do this on macro?
  6. A

    how can i work on percentage's in VBA

    Hi All, i have 2 columns with values and i need it to calculate as percentages. like, if A and B Column has 100 and 50 then i need it to calculate as 100% and 50%. Please help.
  7. A

    Conditional Format for 4 condition

    thanks a lot Sir... u helped me a lot i understood a lot with this macro. :)
  8. A

    Conditional Format for 4 condition

    Hi Sir, i understood the macro... But what my question is instead of colouring the cell is there an other option like no-fill(no colour) in Case Is section
  9. A

    Conditional Format for 4 condition

  10. A

    Conditional Format for 4 condition

    Narayan Sir ...It worked like a charm. Ty and one more request sir how can i give No fill in Case Is >= 80% cell.Resize(1, 4).Interior.Color = vbSGreen ?
  11. A

    Conditional Format for 4 condition

    yes sir and should apply same law/condition for same range of cells too
  12. A

    Conditional Format for 4 condition

    no sir. even this last macro is not working on it Scenario: when A% and B% is applied with the condition then only those 2 columns should be higlighted and same case applies with C% and D%. condition is all we need to apply :( Condition: (A+B) >= 90% = Purple 90% >(A+B)>=...
  13. A

    Conditional Format for 4 condition

    Hi Narayan Sir... the above macro works only on A% and B% i need it for all A,B,C,D. and please let me know how to add different colours too.Thanks in advance.
  14. A

    Conditional Format for 4 condition

    Hi Sir, Please check the below attached sample paper. and i need to apply condition(coloured) as given in my 1st post and that will get hightlighted on calculations + column E, F, G, H... https://www.box.com/s/xqos9y3n84q4ojzzren6 like if A + B >= 90% then highlight E and F column in...
  15. A

    Conditional Format for 4 condition

    Hi All, i have below macro using. But what i need is instead of giving the keyword like Extreme, medium, low or something. can anyone please let me know how can i use aggregate percentage for each cell... like given on below given condition and i need to make 4 columns like a, b, c & d at...
See more
Back
Top