Change cell color if data present excel 2002
 

I have a worksheet with two columns and multiple rows of data in a
workbook that contains multiple sheets. Column "A" has location
information and column "B" has the owner information. I would like to
know how to automate the sheet to look at column "A" and if there is
data present then look at the corresponding cell in column "B" (i.e
"A3" then look at "B3") and if there isn't any data in "B" then change
the color.

Change cell color if data present excel 2002
 

Hi Mike
try the following
- select cells B1:B100
- goto Format - conditional Format
- enter the following formula
=(A1<"")*(B1="")
- choose a color

--
Regards
Frank Kabel
Frankfurt, Germany


Mike wrote:
I have a worksheet with two columns and multiple rows of data in a
workbook that contains multiple sheets. Column "A" has location
information and column "B" has the owner information. I would like
to
know how to automate the sheet to look at column "A" and if there is
data present then look at the corresponding cell in column "B" (i.e
"A3" then look at "B3") and if there isn't any data in "B" then
change
the color.

Change cell color if data present excel 2002
 

Hi Frank,

Thanks for the reply, much appreciated! I used a version of this for
a workaround conditional format selected cells equal a cell that is
outside my range and always blank. I tried to use your code
conditional format condition 1 formula is "your code below".

Nothing changed, I removed my conditional formatting and changed some
of the cells and nothing...I must be doing something wrong?

Mike

"Frank Kabel" wrote in message ...
Hi Mike
try the following
- select cells B1:B100
- goto Format - conditional Format
- enter the following formula
=(A1<"")*(B1="")
- choose a color

--
Regards
Frank Kabel
Frankfurt, Germany


Mike wrote:
I have a worksheet with two columns and multiple rows of data in a
workbook that contains multiple sheets. Column "A" has location
information and column "B" has the owner information. I would like
to
know how to automate the sheet to look at column "A" and if there is
data present then look at the corresponding cell in column "B" (i.e
"A3" then look at "B3") and if there isn't any data in "B" then
change
the color.