Conditional Formatting...
 

Hi Folks,

I need to setup a conditional format based on an adjacent cell value...

Let's take columns B & C for example...

I want to format B1 red if the value of cell C1 is greater than zero and the
value of cell B1 is zero.

The "C" column is populated from another workbook and will not have values
values in each row. I want to visually prompt the user to enter a value in
the "B" column for any row in which the "C" column has a value greater than
zero. Once they enter a value in B the cell should not longer be red.

-Scratching my head...

Conditional Formatting...
 

Use a formula of

=AND($B1=0,$C10)

--
---
HTH

Bob


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



"Stephen" wrote in message
...
Hi Folks,

I need to setup a conditional format based on an adjacent cell value...

Let's take columns B & C for example...

I want to format B1 red if the value of cell C1 is greater than zero and
the
value of cell B1 is zero.

The "C" column is populated from another workbook and will not have values
values in each row. I want to visually prompt the user to enter a value
in
the "B" column for any row in which the "C" column has a value greater
than
zero. Once they enter a value in B the cell should not longer be red.

-Scratching my head...

Conditional Formatting...
 

of course... good deal. thank you!

"Bob Phillips" wrote:

Use a formula of

=AND($B1=0,$C10)

--
---
HTH

Bob


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



"Stephen" wrote in message
...
Hi Folks,

I need to setup a conditional format based on an adjacent cell value...

Let's take columns B & C for example...

I want to format B1 red if the value of cell C1 is greater than zero and
the
value of cell B1 is zero.

The "C" column is populated from another workbook and will not have values
values in each row. I want to visually prompt the user to enter a value
in
the "B" column for any row in which the "C" column has a value greater
than
zero. Once they enter a value in B the cell should not longer be red.

-Scratching my head...