Cell color change In Excel Using Conditional formatting in C#

Posted by Suryakavitha on Stack Overflow See other posts from Stack Overflow or by Suryakavitha
Published on 2010-03-16T09:19:19Z Indexed on 2010/03/16 9:56 UTC
Read the original article Hit count: 239

Filed under:

c#

|

msoffice

|

excel

Hi,

I have exported datatable to excel successfully... Now i have to change some cell color using Conditional formatting in Excel sheet using C#.... For example if a cell contains text as "Cat" it should be display in Green color and if a cell contains text as "Dog" it should display in blue Color.... Now how can i do this ?

Plz Anyone tell me the solution of this ... or give me the code for it...

Thanks In Advance..

© Stack Overflow or respective owner

Related posts about c#

.NET WebRequest.PreAuthenticate not quite what it sounds like

as seen on West-Wind - Search for 'West-Wind'
I’ve run into the problem a few times now: How to pre-authenticate .NET WebRequest calls doing an HTTP call to the server – essentially send authentication credentials on the very first request instead of waiting for a server challenge first? At first glance this sound like it should be easy:… >>> More
HttpWebRequest and Ignoring SSL Certificate Errors

as seen on West-Wind - Search for 'West-Wind'
Man I can't believe this. I'm still mucking around with OFX servers and it drives me absolutely crazy how some these servers are just so unbelievably misconfigured. I've recently hit three different 3 major brokerages which fail HTTP validation with bad or corrupt certificates at least according to… >>> More
Dynamic Type to do away with Reflection

as seen on West-Wind - Search for 'West-Wind'
The dynamic type in C# 4.0 is a welcome addition to the language. One thing I’ve been doing a lot with it is to remove explicit Reflection code that’s often necessary when you ‘dynamically’ need to walk and object hierarchy. In the past I’ve had a number of ReflectionUtils that used string based expressions… >>> More
The dynamic Type in C# Simplifies COM Member Access from Visual FoxPro

as seen on West-Wind - Search for 'West-Wind'
I’ve written quite a bit about Visual FoxPro interoperating with .NET in the past both for ASP.NET interacting with Visual FoxPro COM objects as well as Visual FoxPro calling into .NET code via COM Interop. COM Interop with Visual FoxPro has a number of problems but one of them at least got a lot… >>> More
Finding a Relative Path in .NET

as seen on West-Wind - Search for 'West-Wind'
Here’s a nice and simple path utility that I’ve needed in a number of applications: I need to find a relative path based on a base path. So if I’m working in a folder called c:\temp\templates\ and I want to find a relative path for c:\temp\templates\subdir\test.txt I want to receive back subdir\test… >>> More

Related posts about msoffice

Which office suite is the ideal alternative to MSOffice?

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
Let's say I want to drop MSOffice permanently and switch to a free alternative, not having the need of opening the documents on other PC's except my own (I can also carry a portable version on a pendrive and edit the docs anywhere). I know 3 free office suites - LibreOffice, Abiword and Calligra… >>> More
Translate MSOffice menus from Chinese to English

as seen on Super User - Search for 'Super User'
Hi! I'm stuck in China using a Chinese language MSOffice package (Home and Student). All of the menus and system instructions are in Chinese. I know there's a pack I can buy but that's not an option for this computer and this temporary situation. Is there another way to convert from Chinese to English… >>> More
=rand(100,60) - MSOffice Problem

as seen on Stack Overflow - Search for 'Stack Overflow'
Oho ! Have you tried this one ?? Very simple office utility question. The question is something like this. Open Microsoft word ( 2003 or 2007 ) whatever you use. ( Let me clarify that - I am not here for any kind of advertisement of Micro soft - I want to solution to my Query ) After opening… >>> More
Excel 2007 Save as PDF with pagesize/pagewidth auto or not breaking Excel lines.

as seen on Super User - Search for 'Super User'
Hi everyone! I tried to export an Excel file into PDF, but it looks horrible. I need at least that one row form Excel to be saved into a one row in PDF. I know that it is not so simple, because Excel does no have any page size. At least, they could make some estimations. Can anyone recommend me… >>> More
Detect whether Office 2010 is 32bit or 64bit via the registry

as seen on Stack Overflow - Search for 'Stack Overflow'
Now that Office 2010 also comes in a 64bit install, where in the registry do you find out if the version of Office installed is 32bit or 64bit? >>> More