Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I convert conditional formatting into explicit formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |