Row Formatting

[Guest]

Hi All,

How can I format a complete row or range automatically, depending on Cell
value or comparison between 2 values at different cells. ? Conditional
formating is doing this just for one cell only and depending on the value of
this cell.

Any solution.
--
*********
IT Manager
DeLaval Ltd.
Cairo-Egypt
*********
|-----------------------------|
|Islam is peace not Terror|
|-----------------------------|

 

[Frank Kabel]

Hi
conditional formating can do this as well:
- select the row (e.g. row 1)
- goto Conditional Format dialog
- enter the following formula
=$A1>1
- choose your format

This will format row 1 if A1 is larger than one.

-----Original Message-----
Hi All,

How can I format a complete row or range

automatically, depending on Cell

 

[markstro]

It took awhile, but I think I got it figured out, if you can duplicate this, great.
format A1 for =today()
conditional formatting cell a2 with three conditions as follows:
condition one: =if($a$2<$a$1,true,false) and format as needed
condition two: =and($a$2>$a$1,$a$2<($a$1+91))and format as needed
condition three =and($a$2>$a$1,$a$2<($a$1+181))and format as needed
Hope this helps, curious if it does.

 

[markstro]

P.S. from my last posting, copy that formatting across the whole row
and the whole row should change according to the date in A2.
Good Luck