simple function

[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

 

[davis]

use the conditioning format
Click on format, select conditioning format

 

[Earl Kiosterud]

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.

 

[Guest]

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.

 

[Peo Sjoblom]

Then you have to use conditional formatting on the other cell referencing
the first cell.
What's your formula/condition?

 

[Guest]

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.

 

[Peo Sjoblom]

Select formula is instead of cell value from the dropdown and then refer to
A1

 

[Guest]

WOW... THANKS!