Help Please
 

Hi All,
I have developed an application using Visual Basic & Access. My query is i
am getting the report from access database to excel while exporting data from
access to excel i want all the cell with NO to be filled with red color this
can be done by conditional formatting but i want this to be automated as soon
this is extracted from access database.

TIA

Help Please
 

You can add the CF in the code that gets the data

Dim rng As Range


Set rng = Range("A:B") '<=== change to suit
rng.FormatConditions.Delete
rng.FormatConditions.Add Type:=xlExpression, Formula1:="=RC=""Yes"""
rng.FormatConditions(1).Interior.ColorIndex = 3
Set rng = Nothing


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"kiran" wrote in message
...
Hi All,
I have developed an application using Visual Basic & Access. My query is i
am getting the report from access database to excel while exporting data
from
access to excel i want all the cell with NO to be filled with red color
this
can be done by conditional formatting but i want this to be automated as
soon
this is extracted from access database.

TIA