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