simple function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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.
 
Then you have to use conditional formatting on the other cell referencing
the first cell.
What's your formula/condition?
 
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.
 
Back
Top