I think you'll have to give more details to get any good response.

Leeney wrote:

Hi Dave,

Thank you very much. It does work. There are 16 pages I'm pulling from so
I would have to repeat the following in 16 times. ugh I'm trying to figure
out how to put in an "OR" statement but an hoping there may be something
easier?

=IF(CEB!AA3="","",CEB!AA3)

Thank you
Leeney

"Dave Peterson" wrote:

I put this formula in A1: =if(b1="","",b1)

And I used a custom rule of: =A1<""
for the format|conditional formatting of A1.

It seemed to work ok.

Leeney wrote:

I want to use conditional format in a programmed cell. I have a workbook
with many pages. The result page pulls people's initials from the rest of
the workbook. I need to color in the cell if initials are there.
Conditional format seems to see the formula as a parameter.

Thnx for your help.

Leeney

--

Dave Peterson


--

Dave Peterson