Row Formatting

I

Ibrahim Awwad

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|
|-----------------------------|
 
F

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
Click to expand...
automatically, depending on Cell
 
M

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

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
 
Top