programmerz
New Member
- Joined
- Apr 27, 2010
- Messages
- 6
Hi all,
I have a few question about excel. Please refer to the table below.
<table x:str="" style="border-collapse: collapse; width: 144pt;" border="0" cellpadding="0" cellspacing="0" width="192"><col style="width: 48pt;" span="3" width="64"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt; width: 48pt;" height="17" width="64">
</td> <td class="xl66" style="border-left: medium none; width: 48pt;" width="64">Debit</td> <td class="xl67" style="border-left: medium none; width: 48pt;" width="64">Credit</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl68" style="height: 12.75pt; border-top: medium none;" height="17">Item A</td> <td class="xl69" style="border-top: medium none; border-left: medium none;" x:num="">23</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" x:num="">15</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl68" style="height: 12.75pt; border-top: medium none;" height="17">Item B</td> <td class="xl69" style="border-top: medium none; border-left: medium none;" x:num="">43</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" x:num="">42</td> </tr> <tr style="height: 13.5pt;" height="18"> <td class="xl71" style="height: 13.5pt; border-top: medium none;" height="18">Item C</td> <td class="xl72" style="border-top: medium none; border-left: medium none;" x:num="">21</td> <td class="xl73" style="border-top: medium none; border-left: medium none;" x:num="">51</td> </tr> </tbody></table>
1. Is it possible to create simple rule like this?
If Column A contains Item C, then color that row (A3-AC) with red color.
2. If Column A contains Item C, then copy the Credit value of Item C in F4
Please let me know if you need more information.
Thanks in advance.
I have a few question about excel. Please refer to the table below.
<table x:str="" style="border-collapse: collapse; width: 144pt;" border="0" cellpadding="0" cellspacing="0" width="192"><col style="width: 48pt;" span="3" width="64"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt; width: 48pt;" height="17" width="64">
</td> <td class="xl66" style="border-left: medium none; width: 48pt;" width="64">Debit</td> <td class="xl67" style="border-left: medium none; width: 48pt;" width="64">Credit</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl68" style="height: 12.75pt; border-top: medium none;" height="17">Item A</td> <td class="xl69" style="border-top: medium none; border-left: medium none;" x:num="">23</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" x:num="">15</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl68" style="height: 12.75pt; border-top: medium none;" height="17">Item B</td> <td class="xl69" style="border-top: medium none; border-left: medium none;" x:num="">43</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" x:num="">42</td> </tr> <tr style="height: 13.5pt;" height="18"> <td class="xl71" style="height: 13.5pt; border-top: medium none;" height="18">Item C</td> <td class="xl72" style="border-top: medium none; border-left: medium none;" x:num="">21</td> <td class="xl73" style="border-top: medium none; border-left: medium none;" x:num="">51</td> </tr> </tbody></table>
1. Is it possible to create simple rule like this?
If Column A contains Item C, then color that row (A3-AC) with red color.
2. If Column A contains Item C, then copy the Credit value of Item C in F4
Please let me know if you need more information.
Thanks in advance.