If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
simple function
Hi, I have a simple function to figure out but without
much experience. I hope someone will answer. Let's say I have two columns A & B. I want a formula in column B1 to say "If A1 = N, then B1 cell should color yellow. If A1 = Y, then B1 cell should color green" Can anyone help? Thanks! Pauline |
#2
|
|||
|
|||
simple function
use the conditioning format
Click on format, select conditioning format -----Original Message----- Hi, I have a simple function to figure out but without much experience. I hope someone will answer. Let's say I have two columns A & B. I want a formula in column B1 to say "If A1 = N, then B1 cell should color yellow. If A1 = Y, then B1 cell should color green" Can anyone help? Thanks! Pauline . |
#3
|
|||
|
|||
simple function
Pauline,
You don't really want a function per se. Functions are things like SUM(...) and live in formulas. Use Conditional Formatting (Format menu). You can have three different colors based on three values (and a fourth color, the regular formatted color) when none of the three values is true. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- wrote in message ... Hi, I have a simple function to figure out but without much experience. I hope someone will answer. Let's say I have two columns A & B. I want a formula in column B1 to say "If A1 = N, then B1 cell should color yellow. If A1 = Y, then B1 cell should color green" Can anyone help? Thanks! Pauline |
#4
|
|||
|
|||
simple function
when I do the conditional formatting, it only effects the
cell that you use to do the conditional formatting in. I need the formatting to apply to another cell. |
#5
|
|||
|
|||
simple function
Then you have to use conditional formatting on the other cell referencing
the first cell. What's your formula/condition? -- Regards, Peo Sjoblom wrote in message ... when I do the conditional formatting, it only effects the cell that you use to do the conditional formatting in. I need the formatting to apply to another cell. |
#6
|
|||
|
|||
simple function
I'm working with 2 cells (which I plan to copy to all the
other cells in each column respectively). Cell A1 has a condition to color it green if "Y" is entered into it or red if a "N" is entered into it. Cell B1 is where I want a condition to reference cell A1. If cell A1= "N", I want cell B1 to shade yellow. If cell A1 = "Y", then nothing changes to cell B1. I just can't see where I can reference a cell to conditionally format other than the cell I'm in when I go to conditional format. |
#7
|
|||
|
|||
simple function
Select formula is instead of cell value from the dropdown and then refer to
A1 -- Regards, Peo Sjoblom wrote in message ... I'm working with 2 cells (which I plan to copy to all the other cells in each column respectively). Cell A1 has a condition to color it green if "Y" is entered into it or red if a "N" is entered into it. Cell B1 is where I want a condition to reference cell A1. If cell A1= "N", I want cell B1 to shade yellow. If cell A1 = "Y", then nothing changes to cell B1. I just can't see where I can reference a cell to conditionally format other than the cell I'm in when I go to conditional format. |
#8
|
|||
|
|||
simple function
WOW... THANKS!
|
Thread Tools | |
Display Modes | |
|
|