• 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 r_2

  1. R

    multiple if criteria with 3 results option

    thnx swapnil ...
  2. R

    multiple if criteria with 3 results option

    hi following are the requirement if d = pending with UIDAI(DQC) & E= ""(blank) column G will reflect pending with customer. if d= other option & E=blank column G will reflect pending wth team. if E= non blank column G will reflect closed my column F function is working , were if criteria is...
  3. R

    conditional formatting for cumulative frequency

    hi, Iam looking for formula to do conditional formatting with cumulative frequency. Ex- 10-29 (yellow color) 30- 49 (Orange color) 50 & above (Red color) Excel sheet is attached for your reference( conditional formating required for colum d,e,f,g ,i,j,k,l) Pls guide
  4. R

    conditional formatting for not equal to value in two rows

    hi, need the conditional formatting , where if two selected rows are not have same text or numerical will highlight the 1st column. EX if A<>B, highlight A, RED. in attachment the requirement is, C<>G, highlight C, RED. D<>I, highlight D, Green.
  5. R

    hi, need a help on setting if criteria on specific date

    hi, need a help on setting if criteria on specific date. While for calculation of TAT days before a specific date I need to set a another column against which their desired deadlines are set so that i can calculate their networkdays by subtracting it EX- if a item was delivered in a location...
  6. R

    Highlight column and row of active cell but retaining the previous formats

    hi can any one help me on this through conditional formatting, new rule if i write=ROW(A1)=selRow =COLUMN(A1)=selCol it converts into =COLUMN(A1)=selCol =ROW(XEV1)=selrow & didn't get any result.... Pls suggest why iam getting error
  7. R

    if criteria( need help)

    Hi, Unable to get the desired result. Requirement: in column D, source is column C if c5 >200 , D5=7 c6 <=200 , D6=5 c7 <=200, d7= 5
  8. R

    countif for multiple criteria

    Hi Deepak, I need the count of row. pls reply. Thnx
  9. R

    countif for multiple criteria

    Hi hui, I need the count of row. pls reply. Thnx
  10. R

    countif for multiple criteria

    Hi, Unable to do it, with multiple criteria range. 1) countifs require for sales(column C, against column A, mgr) Required to find out count of sales against mgr, but store location should be required to taken in critera to find the count as 2 mgrs are taking care of same location
  11. R

    Conditional formatting & if criteria

    thnx luke & p45cal
  12. R

    Conditional formatting & if criteria

    hi, unable to do that, it will be helpful if u mention the stepwise step.
Back
Top