Thank you , will try Sent from my iPhone
On Dec 6, 2012, at 12:49 PM, Abdul Shukoor <[email protected]> wrote: > Fill the active sheet cell as C1= Pass, C2=Fail, C3=Warning, C4=Pass and C5= > Fail and so on. Add the following macro as follows: You are good to go. Let > me know if you have any issues with this. > > Private Sub Workbook_Open() > > ConditionallyFormatCells > > End Sub > > > Sub ConditionallyFormatCells() > > > ' Fill the active sheet cell as C1= Pass, C2=Fail, C3=Warning, C4=Pass and > C5= Fail and so on. > > > Set MyPlage = Range("C1:C100") > > For Each Cell In MyPlage > > If Cell.Value = "Pass" Then > Cell.Interior.Color = 5287936 > End If > > If Cell.Value = "Fail" Then > Cell.Interior.Color = 255 > > End If > If Cell.Value = "Warning" Then > Cell.Interior.Color = 49407 > > End If > If Cell.Value <> "Pass" And Cell.Value <> "Fail" And Cell.Value <> > "Warning" And Cell.Value <> "" Then > Cell.Interior.ColorIndex = xlNone > End If > > Next > End Sub > > > > > > > > > > > > On Thu, Dec 6, 2012 at 9:35 AM, <[email protected]> wrote: >> Could you guide steps or any link abt macro >> >> Sent from my iPhone >> >> On Dec 6, 2012, at 8:18 AM, Abdul Shukoor <[email protected]> wrote: >> >>> You can try adding auto exec macro to output data table that will to >>> conditionally format the result xls file when open it Excel. >>> >>> >>> >>> On Wed, Dec 5, 2012 at 9:55 AM, Rasim Avci <[email protected]> wrote: >>>> I am not sure if QTP data table has this kind of color property. >>>> >>>> QTP data table looks like excel much but has not all the >>>> functionalities of the excel tables, as far as I know. >>>> >>>> 2012/12/5, Kiran Ogeti <[email protected]>: >>>> > Not sure if this is super simple or hard to do, but just have to ask >>>> > >>>> > I am marking pass or fail in the data table and would like to highlight >>>> > with >>>> > some color for the rows which are Fail in datatable (not in excel but QTP >>>> > datatable) >>>> > >>>> > Could you advise >>>> > >>>> > Thanks >>>> > >>>> > -- >>>> > You received this message because you are subscribed to the Google >>>> > "QTP - HP Quick Test Professional - Automated Software Testing" >>>> > group. >>>> > To post to this group, send email to [email protected] >>>> > To unsubscribe from this group, send email to >>>> > [email protected] >>>> > For more options, visit this group at >>>> > http://groups.google.com/group/MercuryQTP?hl=en >>>> > >>>> >>>> >>>> -- >>>> Rasim Avcı >>>> >>>> -- >>>> You received this message because you are subscribed to the Google >>>> "QTP - HP Quick Test Professional - Automated Software Testing" >>>> group. >>>> To post to this group, send email to [email protected] >>>> To unsubscribe from this group, send email to >>>> [email protected] >>>> For more options, visit this group at >>>> http://groups.google.com/group/MercuryQTP?hl=en >>> >>> -- >>> You received this message because you are subscribed to the Google >>> "QTP - HP Quick Test Professional - Automated Software Testing" >>> group. >>> To post to this group, send email to [email protected] >>> To unsubscribe from this group, send email to >>> [email protected] >>> For more options, visit this group at >>> http://groups.google.com/group/MercuryQTP?hl=en >> >> -- >> You received this message because you are subscribed to the Google >> "QTP - HP Quick Test Professional - Automated Software Testing" >> group. >> To post to this group, send email to [email protected] >> To unsubscribe from this group, send email to >> [email protected] >> For more options, visit this group at >> http://groups.google.com/group/MercuryQTP?hl=en > > -- > You received this message because you are subscribed to the Google > "QTP - HP Quick Test Professional - Automated Software Testing" > group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group at > http://groups.google.com/group/MercuryQTP?hl=en -- You received this message because you are subscribed to the Google "QTP - HP Quick Test Professional - Automated Software Testing" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/MercuryQTP?hl=en
