Looping Format


"Excel VBA Help"

 


Play Friv Now - Play Friv Games
Go Back   The Code Cage Forums > Microsoft Topics > Microsoft Excel Forum
Our Info Pages:-
The Code Cage - Microsoft Office help

Notices

Microsoft Excel Forum Members Post questions in this forum if they are related to using Microsoft Excel, this includes Worksheet Functions, Excel VBA Programming, Simple Macro Code & Charting, Excel formula etc.

 
 
Thread Tools Rate Thread Display Modes
  #1  
Old 17th May 2010, 16:54
Totoshi's Avatar
Totoshi
Newsgroup Contributor
 
Posts: n/a
Posts Per Day: 0
My Top Tip Count:
Default Looping Format
     Excel: Functions   


------ Register to get rid of these "In Post" ads! ------

Category: Excel: Functions   

Hi everyone,

I need some help a looping format, here is the problem:

I have data in col A B C , and i need each time both A1 B1 C1 is equal
to zero the text color is white, and so on until A100 B100 C100; i
have thinking in someting but is not working...

Can you help me....


Thanks


______________________

Sub color()
Dim icol As Integer
Dim ilin As Integer
Dim r As Range

ilin = 0
icol = 0
Sheets("Certificado").Select
For ilin = 0 To ilin = 114
If (r.Cells(ilin, 1) = 0 And r.Cells(ilin, 2) = 0 And r.Cells(ilin,
3) = 0) Then
'Range(Cells(ilin1, 1), Cells(ilin1, 2), Cells(ilin1, 3)).Select
Font.ColorIndex = 2
End If
Next ilin



The Code Cage Advertisment
Advertisement
  #2  
Old 17th May 2010, 17:39
Luke M's Avatar
Luke M
Newsgroup Contributor
 
Posts: n/a
Posts Per Day: 0
My Top Tip Count:
Default Re: Looping Format

------ Register to get rid of these "In Post" ads! ------


With all cells selected, cell A1 active, conditional format formula is:
=AND($A1=$B1,$A1=$C1,$A1=0)
format to white text.

This format can be applied to all cells/rows within selection.

--
Best Regards,

Luke M
"Totoshi" <jferreira80@gmail.com> wrote in message
news:83e965e5-2c28-4de7-8478-cb6b23eab90c@z17g2000vbd.googlegroups.com...
> Hi everyone,
>
> I need some help a looping format, here is the problem:
>
> I have data in col A B C , and i need each time both A1 B1 C1 is equal
> to zero the text color is white, and so on until A100 B100 C100; i
> have thinking in someting but is not working...
>
> Can you help me....
>
>
> Thanks
>
>
> ______________________
>
> Sub color()
> Dim icol As Integer
> Dim ilin As Integer
> Dim r As Range
>
> ilin = 0
> icol = 0
> Sheets("Certificado").Select
> For ilin = 0 To ilin = 114
> If (r.Cells(ilin, 1) = 0 And r.Cells(ilin, 2) = 0 And r.Cells(ilin,
> 3) = 0) Then
> 'Range(Cells(ilin1, 1), Cells(ilin1, 2), Cells(ilin1, 3)).Select
> Font.ColorIndex = 2
> End If
> Next ilin






  #3  
Old 17th May 2010, 17:56
Rick Rothstein's Avatar
Rick Rothstein
Newsgroup Contributor
 
Posts: n/a
Posts Per Day: 0
My Top Tip Count:
Default Re: Looping Format

------ Register to get rid of these "In Post" ads! ------


Why not just this...

=AND($A1=0,$B1=0,$C1=0)

....seems like that would work as well and the structure is much simpler.

--
Rick (MVP - Excel)



"Luke M" <lukemoraga@nospam.com> wrote in message
news:#qq3u8d9KHA.508@TK2MSFTNGP06.phx.gbl...
> With all cells selected, cell A1 active, conditional format formula is:
> =AND($A1=$B1,$A1=$C1,$A1=0)
> format to white text.
>
> This format can be applied to all cells/rows within selection.
>
> --
> Best Regards,
>
> Luke M
> "Totoshi" <jferreira80@gmail.com> wrote in message
> news:83e965e5-2c28-4de7-8478-cb6b23eab90c@z17g2000vbd.googlegroups.com...
>> Hi everyone,
>>
>> I need some help a looping format, here is the problem:
>>
>> I have data in col A B C , and i need each time both A1 B1 C1 is equal
>> to zero the text color is white, and so on until A100 B100 C100; i
>> have thinking in someting but is not working...
>>
>> Can you help me....
>>
>>
>> Thanks
>>
>>
>> ______________________
>>
>> Sub color()
>> Dim icol As Integer
>> Dim ilin As Integer
>> Dim r As Range
>>
>> ilin = 0
>> icol = 0
>> Sheets("Certificado").Select
>> For ilin = 0 To ilin = 114
>> If (r.Cells(ilin, 1) = 0 And r.Cells(ilin, 2) = 0 And r.Cells(ilin,
>> 3) = 0) Then
>> 'Range(Cells(ilin1, 1), Cells(ilin1, 2), Cells(ilin1, 3)).Select
>> Font.ColorIndex = 2
>> End If
>> Next ilin

>
>




The Code Cage Advertisment
Advertisement
  #4  
Old 17th May 2010, 18:10
Totoshi's Avatar
Totoshi
Newsgroup Contributor
 
Posts: n/a
Posts Per Day: 0
My Top Tip Count:
Default Re: Looping Format

------ Register to get rid of these "In Post" ads! ------


It works just fine,


Thanks



The Code Cage Advertisment
Advertisement
 
The Code Cage at Facebookhe Code Cage at Twitter


Tags
format, looping

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

The Code Cage Affilliates



http://www.thecodecage.com/forumz tested by McAfee Security http://www.thecodecage.com/forumz tested by McAfee Security

All times are GMT +1. The time now is 02:07.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Template-Modifications by TMS
No part of this board, functionality or creatives may be copied or reproduced either in part or full without the express permission of The Code Cage Team.
Copyright ©2008 - , Simon lloyd.
We are not associated with nor employed by Microsoft in any way, we simply provide resources!
All MS office icons are registered trademarks of the application they represent and are used with permission from Microsoft
UA-8135493-1
Cultural Forum | Study at Malaysian University
X vBulletin 3.8.7 Debug Information
  • Page Generation 0.17762 seconds
  • Memory Usage 6,320KB
  • Queries Executed 17 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footerEnd
  • (1)ad_footerStart
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_headerEnd
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_leftcolumn_code
  • (1)ad_navbar_below
  • (3)ad_postbit_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (4)helpful_answers
  • (1)helpfulanswers_javascript
  • (1)navbar
  • (3)navbar_link
  • (3)navbar_noticebit
  • (52)option
  • (4)post_thanks_box
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (4)post_thanks_postbit_info
  • (4)postbit
  • (4)postbit_ctoptip
  • (4)postbit_wrapper
  • (1)showthread_changepostsowner_link
  • (1)showthread_extra_fields
  • (1)showthread_quickreply_mrgdp
  • (1)showthread_reason_popup
  • (1)spacer_close
  • (1)spacer_open
  • (1)su_form
  • (2)tagbit
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_datastore.php
  • ./includes/class_hook.php
  • ./awcoding/plugins/awc.php
  • ./awcoding/plugins/ds.php
  • ./awcoding/plugins/ss.php
  • ./includes/functions_notice.php
  • ./mobiquo/smartbanner.php
  • ./mobiquo/include/classTTConnection.php
  • ./mobiquo/smartbanner/head.inc.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/vbatags.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php
  • ./includes/functions_misc.php
  • ./includes/functions_prefix.php 

Hooks Called:
  • init_startup
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • fetch_musername
  • notices_check_start
  • notices_check_criteria
  • notices_noticebit
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • helpfulanswers_showthreadorpost
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • helpfulanswers_show_normal
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • error_fetch
  • tag_fetchbit
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete