I know how to do this for a cell, but can i make other cell change the format
dependant on what the cell value is.
eg. V8 is above 4 so A8:M8 will be highlight in red.

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

I need to change the color of a column (date) after 90 days. I have
already used my 3 wishes in the conditional formatting. Can anyone
tell me how to change a fourth?

Thanks,

MaureenB


--
MaureenB
------------------------------------------------------------------------
MaureenB's Profile: http://www.excelforum.com/member.php...o&userid=28261
View this thread: http://www.excelforum.com/showthread...hreadid=478227

Maureen, check out these links:

John McGimpsey has an article on doing up to 6
www.mcgimpsey.com/excel/conditional6.html

- Bob Phillips & Frank Kabel have developed an excel add-in
http://www.xldynamic.com/source/xld...s.Downlaod.html


--
neopolitan


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

small answer, & not expert, but I often use orignal cell color / format as
4th condition; presumes 1 of other 4 is more often set; if that works for
you, may need to flip logic on conditional formats..

"MaureenB" wrote:


I need to change the color of a column (date) after 90 days. I have
already used my 3 wishes in the conditional formatting. Can anyone
tell me how to change a fourth?

Thanks,

MaureenB


--
MaureenB
------------------------------------------------------------------------
MaureenB's Profile: http://www.excelforum.com/member.php...o&userid=28261
View this thread: http://www.excelforum.com/showthread...hreadid=478227

part 2, missed saying: if have equation, use excusion for all less than (to
get a blank field), you then have a 4th condition. hope that helps. later

"nastech" wrote:

small answer, & not expert, but I often use orignal cell color / format as
4th condition; presumes 1 of other 4 is more often set; if that works for
you, may need to flip logic on conditional formats..

"MaureenB" wrote:


I need to change the color of a column (date) after 90 days. I have
already used my 3 wishes in the conditional formatting. Can anyone
tell me how to change a fourth?

Thanks,

MaureenB


--
MaureenB
------------------------------------------------------------------------
MaureenB's Profile: http://www.excelforum.com/member.php...o&userid=28261
View this thread: http://www.excelforum.com/showthread...hreadid=478227