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
