excel conditional formatting for text using perl

Muchacho has asked for the wisdom of the Perl Monks concerning the following question:

Hello,

I have a perl script which parses logs into an excel sheet. I would like to add conditional formatting so some cells.

I could only find how to add conditional formatting for numbers. However, I would like to use conditonal formatting for text.

If the cell contains the text 'Passed', I would like its background to be green.

If the cell contains the text 'Failed', I would like its background to be red etc. What is the syntax for that?

Thanks.

Comment on excel conditional formatting for text using perl

Replies are listed 'Best First'.
Re: excel conditional formatting for text using perl by Khen1950fx (Canon) on Aug 16, 2011 at 08:41 UTC
This question is often asked. I used Super Search to find this. See: Re^3: Conditional Formatting with Spreadsheet::WriteExcel. That should give you a good starting point.	[reply]