Here's one way to set it up ..
Sample construct at:
http://cjoint.com/?mqddSmGPsp
Conditional_Formatting_Swiatkowski_Peter_gen.xls
Select cols B to F
(ensure cell B1 is active by selecting the col header B first,
then sweep to col header F)
Click Format > Conditional Formatting
Make the settings as:
Condition 1:
Formula is: =AND(B1>$A1,B1<>"")
Click Format button > Patterns tab > Green > OK
Condition 2:
Formula is: =AND(B1<$A1,B1<>"")
Click Format button > Patterns tab > Red > Font tab > white font / bold > OK
Click OK at the main dialog
The above will conditionally format cols B to F in the desired manner
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Swiatkowski Peter" <(E-Mail Removed)> wrote in message
news:nsOdnbhx54HyQDzeRVn-(E-Mail Removed)...
> Conditional Formatting with Relative Reference.
>
> Sample workbook:
>
> A B C D E F
>
>
> 1. 4.5 6 7.4 8.3 10 2
>
> 2. 1 2 3 4 3 2
>
> 3. 1 2 3 4 5 6
>
> 4. 6 5 4 3 2 1
>
>
>
> Hi,
>
> How can Excel 2003 workbook be designed so that if a value of a cell is
> smaller or greater than the value of the cell, then color of the cell is
> auto formatted ?
>
> Formatting of the cell is as follows: Green if value is greater and Red if
> the value is smaller.
>
> Desired result based on the above sample workbook:
>
> A B C D E F
>
> 1. 4.5 Green Green Green Green Red
>
> 2. 1 Green Green Green Red Red
>
> 3. 1 Green Green Green Green Green
>
> 4. 6 Red Red Red Red Red
>
>
> Peter
>
>
Similar Threads
