Could you give some test data and expected results???


--
malik641


------------------------------------------------------------------------
malik641's Profile: http://www.excelforum.com/member.php...o&userid=24190
View this thread: http://www.excelforum.com/showthread...hreadid=390141

I want the formatting to work like this:

If C79 = Y then the cells in E12:E66 turn green


--
ANDYPAND
------------------------------------------------------------------------
ANDYPAND's Profile: http://www.excelforum.com/member.php...o&userid=25351
View this thread: http://www.excelforum.com/showthread...hreadid=390141

Highlight cells E12:E66 then go to Format-Conditional Formatting then
choose "Formula is" and write:

=$C$79="Y"

Then click the format button next to the sample text and choose
Patterns and then whatever color you want (in this case, green) and
click OK, and that should be it.

Let me know if it works out.


--
malik641


------------------------------------------------------------------------
malik641's Profile: http://www.excelforum.com/member.php...o&userid=24190
View this thread: http://www.excelforum.com/showthread...hreadid=390141

Thanks Marcus and all - it works now.
I think I must have tried all sorts of combinations apart from the
actual one that works- til now :)


--
ANDYPAND
------------------------------------------------------------------------
ANDYPAND's Profile: http://www.excelforum.com/member.php...o&userid=25351
View this thread: http://www.excelforum.com/showthread...hreadid=390141

Glad to hear it!

ANDYPAND Wrote:
Thanks Marcus and all - it works now.
I think I must have tried all sorts of combinations apart from the
actual one that works- til now :)


--
malik641


------------------------------------------------------------------------
malik641's Profile: http://www.excelforum.com/member.php...o&userid=24190
View this thread: http://www.excelforum.com/showthread...hreadid=390141