Absolutely.

Select the cells whose color you want to change(A8:M8 in your example).


Click on FormatConditional Formatting

Enter the formula: =V84

Set the format options you want (background color, font, etc)

Click Okay.


--
neopolitan


------------------------------------------------------------------------
neopolitan's Profile: http://www.excelforum.com/member.php...nfo&userid=611
View this thread: http://www.excelforum.com/showthread...hreadid=478227