Conditional formatting

C

Chris

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.
 
N

neopolitan

Absolutely.

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


Click on Format>Conditional Formatting

Enter the formula: =V8>4

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

Click Okay.
 
M

MaureenB

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

Thanks,

Maureen
 
N

nastech

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..
 
N

nastech

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
 
Top