Conditional formatting

[Aardvark]

Hi folks,

I have some text in columns A and B that I want to go red if column D
contains a y. Under conditional formatting I set a formula =d8="y" This
isn't working and suggestions would be welcome!

Thanks,

Danny

 

[Debra Dalgleish]

If cell A8 is the active cell, use the formula: =$D8="y"

 

[vvenkat70]

Just add $ to C1 - it should show as $C$1 This will work.

 

[Aardvark]

Dear all,

Thanks, it worked but a bit confused as to why. Why does it need a $? The
column reference is not changing anyway!

Enlightenment would be welcomed

D

 

[Debra Dalgleish]

The column doesn't change, but its position relative to A8 is different
than its position relative to B8.

If you select cells A8:B20, and enter the formula without the absolute
reference, the formula will be adjusted for the cells in column B. Those
cells will check column E for a "y".