I have a formula in column A that is Y or N based on the results in another
cell.

If it is Y, I would like to turn the date in another column to turn Red.

I have gone into the conditional formatting menu and selected formula is.
Then typed in $C$2 = Y and changed the format color to red. C2 does in fact
= Y, but the color doesn't change. Any insight into what I am doing wrong?

You have to say C2="Y"

but you are talking about column A, column C and "another" column, so
I hope my answer helps.

Carlo

On Jan 11, 1:00*pm, melaniem
wrote:
I have a formula in column A that is Y or N based on the results in another
cell.

If it is Y, I would like to turn the date in another column to turn Red.

I have gone into the conditional formatting menu and selected formula is. *
Then typed in $C$2 = Y and changed the format color to red. *C2 does in fact
= Y, but the color doesn't change. *Any insight into what I am doing wrong?

Try the Formula Is option but type the formula like this:

=$C$2="Y"

--
Biff
Microsoft Excel MVP


"melaniem" wrote in message
...
I have a formula in column A that is Y or N based on the results in another
cell.

If it is Y, I would like to turn the date in another column to turn Red.

I have gone into the conditional formatting menu and selected formula is.
Then typed in $C$2 = Y and changed the format color to red. C2 does in
fact
= Y, but the color doesn't change. Any insight into what I am doing
wrong?

=IF($C$2="Y",TRUE,FALSE)

Helps to read a book on Excel before you use it.

Tyro

"melaniem" wrote in message
...
I have a formula in column A that is Y or N based on the results in another
cell.

If it is Y, I would like to turn the date in another column to turn Red.

I have gone into the conditional formatting menu and selected formula is.
Then typed in $C$2 = Y and changed the format color to red. C2 does in
fact
= Y, but the color doesn't change. Any insight into what I am doing
wrong?

Use conditional formatting. See Excel Help on the term.

"melaniem" wrote:

I have a formula in column A that is Y or N based on the results in another
cell.

If it is Y, I would like to turn the date in another column to turn Red.

I have gone into the conditional formatting menu and selected formula is.
Then typed in $C$2 = Y and changed the format color to red. C2 does in fact
= Y, but the color doesn't change. Any insight into what I am doing wrong?

Use conditional formatting. See Excel Help

"melaniem" wrote:

I have a formula in column A that is Y or N based on the results in another
cell.

If it is Y, I would like to turn the date in another column to turn Red.

I have gone into the conditional formatting menu and selected formula is.
Then typed in $C$2 = Y and changed the format color to red. C2 does in fact
= Y, but the color doesn't change. Any insight into what I am doing wrong?

@Tyro:
as $C$2="Y" results in TRUE or FALSE you don't have to check it again.

(Maybe you could find that Info in a Book as well)

Carlo

On Jan 11, 1:18*pm, "Tyro" wrote:
=IF($C$2="Y",TRUE,FALSE)

Helps to read a book on Excel before you use it.

Tyro

"melaniem" wrote in message

...



I have a formula in column A that is Y or N based on the results in another
cell.

If it is Y, I would like to turn the date in another column to turn Red.

I have gone into the conditional formatting menu and selected formula is..
Then typed in $C$2 = Y and changed the format color to red. *C2 does in
fact
= Y, but the color doesn't change. *Any insight into what I am doing
wrong?- Hide quoted text -

- Show quoted text -