Re: $$Excel-Macros$$ conditional formatting

[Blake Bond]

>
> http://tutorialway.com/conditional-cell-format-in-excel/


helpful site 

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Conditional Formatting

[De Premor]

PFA

On 27/12/2014 1:06, Alison Toczko wrote:
Hi. I have a spreadsheet with cells containing month and year (ie. Mar 
2014) without using a day. I would like the cell to be yellow if we 
are in the current month and year, and appear red if the month and 
year has passed. Using Excel 2013, what cell date formatting should I 
use, and how should the formula be structured? Thank you.

--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? 
It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel


FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like 
Please Help, Urgent, Need Help, Formula Problem, Code Problem, and 
Need Advice will not get quick attention or may not be answered.

2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security 
measure.

4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE : Don't ever post confidential data in a workbook. Forum owners 
and members are not responsible for any loss.

---
You received this message because you are subscribed to the Google 
Groups "MS EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send 
an email to excel-macros+unsubscr...@googlegroups.com 
.
To post to this group, send email to excel-macros@googlegroups.com 
.

Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group.

To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


month colour.xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ conditional formatting

[Abhishek Jain]

Help me understand:

Value 0 to 2 = Green
Value greater than 2 = Red

Is this what you want?


On Wed, Feb 20, 2013 at 11:55 AM, Manjunath Narayanappa <
manjunath.narayana...@aon.co.uk> wrote:

>  Dear Expert,
>
>
>
> I want to create conditional formatting for below information
>
> Please help me on this
>
>
>
> Minor (If Cell is =2 should show green &if cell is great than >2 should
> show red)
>
>
>
> Major(If Cell is > 0 red =0 green )
>
>
>
> Thanks
>
> Manjunath
>
> --
>
> PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL
>
>
>
> For Aon’s standard conditions associated with this e-mail please visit
> http://www.aon.com/uk/en/email-footer/aon-uk-limited.jsp
>
> Aon UK Limited
>
> Registered Office: 8 Devonshire Square, London EC2M 4PL
>
> Registered in London No. 210725 . VAT Registration No. 480 8401 48
>
>
>
> Aon UK Limited is authorised and regulated by the Financial Services
> Authority in respect of insurance mediation activities only.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

RE: $$Excel-Macros$$ conditional formatting

[Manjunath Narayanappa]

Yes

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Abhishek Jain
Sent: 20 February 2013 07:09
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ conditional formatting

Help me understand:

Value 0 to 2 = Green
Value greater than 2 = Red

Is this what you want?

On Wed, Feb 20, 2013 at 11:55 AM, Manjunath Narayanappa 
mailto:manjunath.narayana...@aon.co.uk>> wrote:
Dear Expert,

I want to create conditional formatting for below information
Please help me on this

Minor (If Cell is =2 should show green &if cell is great than >2 should show 
red)

Major(If Cell is > 0 red =0 green )

Thanks
Manjunath



PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL



For Aon's standard conditions associated with this e-mail please visit 
http://www.aon.com/uk/en/email-footer/aon-uk-limited.jsp

Aon UK Limited

Registered Office: 8 Devonshire Square, London EC2M 4PL

Registered in London No. 210725 . VAT Registration No. 480 8401 48



Aon UK Limited is authorised and regulated by the Financial Services Authority 
in respect of insurance mediation activities only.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to 
excel-macros+unsubscr...@googlegroups.com<mailto:excel-macros%2bunsubscr...@googlegroups.com>.
To post to this group, send email to 
excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.



--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.





PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL



For Aon's standard conditions associated with this e-mail please visit 
http://www.aon.com/uk/en/email-footer/aon-uk-limited.jsp

Aon UK Limited

Registered Office: 8 Devonshire Square, London EC2M 4PL

Registered in London No. 210725 . VAT Registration No. 480 8401 48



Aon UK Limited is authorised and regulated by the Financial Services Authority 
in respect of insurance mediation activities only.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing c

Re: $$Excel-Macros$$ conditional formatting

[Abhishek Jain]

Check attached.

On Wed, Feb 20, 2013 at 2:18 PM, Manjunath Narayanappa <
manjunath.narayana...@aon.co.uk> wrote:

>  Yes
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Abhishek Jain
> *Sent:* 20 February 2013 07:09
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ conditional formatting
>
>
>
> Help me understand:
>
>
>
> Value 0 to 2 = Green
>
> Value greater than 2 = Red
>
>
>
> Is this what you want?
>
>
>
> On Wed, Feb 20, 2013 at 11:55 AM, Manjunath Narayanappa <
> manjunath.narayana...@aon.co.uk> wrote:
>
> Dear Expert,
>
>
>
> I want to create conditional formatting for below information
>
> Please help me on this
>
>
>
> Minor (If Cell is =2 should show green &if cell is great than >2 should
> show red)
>
>
>
> Major(If Cell is > 0 red =0 green )
>
>
>
> Thanks
>
> Manjunath
>
>
>  --
>
>
> PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL
>
>
>
> For Aon’s standard conditions associated with this e-mail please visit
> http://www.aon.com/uk/en/email-footer/aon-uk-limited.jsp
>
> Aon UK Limited
>
> Registered Office: 8 Devonshire Square, London EC2M 4PL
>
> Registered in London No. 210725 . VAT Registration No. 480 8401 48
>
>
>
> Aon UK Limited is authorised and regulated by the Financial Services
> Authority in respect of insurance mediation activities only.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
> --
>
> PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL
>
>
>
> For Aon’s standard conditions associated with this e-mail please visit
> http://www.aon.com/uk/en/email-footer/aon-uk-limited.jsp
>
> Aon UK Limited
>
> Registered Office: 8 Devonshire Square, London EC2M 4PL
>
> Registered in London No. 210725 . VAT Registration No. 480 8401 48
>
>
>
> Aon UK Limited is authorised and regulated by the Financial Services

Re: $$Excel-Macros$$ conditional formatting

[Abhishek Jain]

Anil has solved your query. Thanks to him.

I have one other question though. In column A, why is the formula
inconsistent? Both values are 2 then why one is green and other is red?

On Wed, Feb 20, 2013 at 3:39 PM, अनिल नारायण गवली
wrote:

> Dear Manjunath,
>
> Pl find attached herewith.
>
> Warm Regards,
> Gawli Anil
>
> On Wed, Feb 20, 2013 at 3:25 PM, Manjunath Narayanappa <
> manjunath.narayana...@aon.co.uk> wrote:
>
>>  Dear Abhi,
>>
>>
>>
>> Please find the attached spreadsheet
>>
>>
>>
>> Rather than input two different formula in two column . Can I get one
>> formula.
>>
>>
>>
>> Thanks
>>
>> Manjunath
>>
>>
>>
>> *From:* Abhishek Jain [mailto:abhishek@gmail.com]
>> *Sent:* 20 February 2013 09:41
>>
>> *To:* Manjunath Narayanappa
>> *Cc:* excel-macros@googlegroups.com
>> *Subject:* Re: FW: $$Excel-Macros$$ conditional formatting
>>
>>
>>
>> Can you share an example data from your end so as to establish what
>> exactly you want?
>>
>> On Wed, Feb 20, 2013 at 2:57 PM, Manjunath Narayanappa <
>> manjunath.narayana...@aon.co.uk> wrote:
>>
>> Dear Abhi,
>>
>>
>>
>> Can I use formula =IF(AND(A6=2,A7>2),"pass","fail") to find pass n fail
>>
>> =IF(AND(A6=0,A7>0),"pass","fail") even if it pop up "pass" it should show
>> green & for fail it should show red
>>
>> Value 0 to 2 = Green
>>
>> Value greater than 2 = Red
>>
>>
>>
>> Thanks
>>
>> Manjunath
>>
>>
>>
>>
>>
>> *From:* Abhishek Jain [mailto:abhishek@gmail.com]
>> *Sent:* 20 February 2013 08:59
>> *To:* Manjunath Narayanappa
>> *Cc:* excel-macros@googlegroups.com
>>
>>
>> *Subject:* Re: $$Excel-Macros$$ conditional formatting
>>
>>
>>
>> Check attached.
>>
>> On Wed, Feb 20, 2013 at 2:18 PM, Manjunath Narayanappa <
>> manjunath.narayana...@aon.co.uk> wrote:
>>
>> Yes
>>
>>
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *Abhishek Jain
>> *Sent:* 20 February 2013 07:09
>> *To:* excel-macros@googlegroups.com
>> *Subject:* Re: $$Excel-Macros$$ conditional formatting
>>
>>
>>
>> Help me understand:
>>
>>
>>
>> Value 0 to 2 = Green
>>
>> Value greater than 2 = Red
>>
>>
>>
>> Is this what you want?
>>
>>
>>
>> On Wed, Feb 20, 2013 at 11:55 AM, Manjunath Narayanappa <
>> manjunath.narayana...@aon.co.uk> wrote:
>>
>> Dear Expert,
>>
>>
>>
>> I want to create conditional formatting for below information
>>
>> Please help me on this
>>
>>
>>
>> Minor (If Cell is =2 should show green &if cell is great than >2 should
>> show red)
>>
>>
>>
>> Major(If Cell is > 0 red =0 green )
>>
>>
>>
>> Thanks
>>
>> Manjunath
>>
>>
>>  --
>>
>>
>> PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL
>>
>>
>>
>> For Aon’s standard conditions associated with this e-mail please visit
>> http://www.aon.com/uk/en/email-footer/aon-uk-limited.jsp
>>
>> Aon UK Limited
>>
>> Registered Office: 8 Devonshire Square, London EC2M 4PL
>>
>> Registered in London No. 210725 . VAT Registration No. 480 8401 48
>>
>>
>>
>> Aon UK Limited is authorised and regulated by the Financial Services
>> Authority in respect of insurance mediation activities only.
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever p

Re: $$Excel-Macros$$ Conditional Formatting

[ashish koul]

can u share a sample file


On Tue, Nov 26, 2013 at 11:19 PM, anon  wrote:

> Hi all,
>
> Using conditional formatting, how can I highlight the smallest-valued cell
> which is greater than 1.5?
>
> Thanks.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>



-- 
*Regards*

*Ashish Koul*


*Visit*
http://www.excelvbamacros.in
Like Us on 
Facebook
Join Us on Facebook 


P Before printing, think about the environment.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Conditional Formatting

[anon]

Attached.

On Tuesday, 26 November 2013 18:06:00 UTC, ashish wrote:
>
> can u share a sample file
>
>
> On Tue, Nov 26, 2013 at 11:19 PM, anon 
> > wrote:
>
>> Hi all,
>>
>> Using conditional formatting, how can I highlight the smallest-valued 
>> cell which is greater than 1.5?
>>
>> Thanks.
>>
>> -- 
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
>> https://www.facebook.com/discussexcel
>>  
>> FORUM RULES
>>  
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security 
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>  
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and 
>> members are not responsible for any loss.
>> --- 
>> You received this message because you are subscribed to the Google Groups 
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to excel-macros...@googlegroups.com .
>> To post to this group, send email to excel-...@googlegroups.com
>> .
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>
>
>
> -- 
> *Regards*
>  
> *Ashish Koul*
>
>
> *Visit*
> http://www.excelvbamacros.in
> Like Us on 
> Facebook
> Join Us on Facebook 
>
>
> P Before printing, think about the environment.
>
>  
>  

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.


Book5.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ conditional formatting

[ashish koul]

try the attachement


On Wed, Nov 27, 2013 at 3:14 PM, Rajesh Agarwal  wrote:

> Dear Friend
> How to put conditional formatting in column b.
> rgds
>
> --
> *Rajesh Kumar Agarwal*
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>



-- 
*Regards*

*Ashish Koul*


*Visit*
http://www.excelvbamacros.in
Like Us on 
Facebook
Join Us on Facebook 


P Before printing, think about the environment.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.


conditional formatting _val.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Conditional Formatting

[ashish koul]

in this case you want to highlight  1.571003


On Wed, Nov 27, 2013 at 2:45 PM, anon  wrote:

> Attached.
>
>
> On Tuesday, 26 November 2013 18:06:00 UTC, ashish wrote:
>
>> can u share a sample file
>>
>>
>> On Tue, Nov 26, 2013 at 11:19 PM, anon  wrote:
>>
>>> Hi all,
>>>
>>> Using conditional formatting, how can I highlight the smallest-valued
>>> cell which is greater than 1.5?
>>>
>>> Thanks.
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros...@googlegroups.com.
>>> To post to this group, send email to excel-...@googlegroups.com.
>>>
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>
>>
>>
>> --
>> *Regards*
>>
>> *Ashish Koul*
>>
>>
>> *Visit*
>> http://www.excelvbamacros.in
>> Like Us on 
>> Facebook
>> Join Us on Facebook 
>>
>>
>> P Before printing, think about the environment.
>>
>>
>>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>



-- 
*Regards*

*Ashish Koul*


*Visit*
http://www.excelvbamacros.in
Like Us on 
Facebook
Join Us on Facebook 


P Before printing, think about the environment.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

RE: $$Excel-Macros$$ conditional formatting

[Ravinder]

pfa

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rajesh Agarwal
Sent: Wednesday, November 27, 2013 3:14 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ conditional formatting

 

Dear Friend

How to put conditional formatting in column b.

rgds


 

-- 
Rajesh Kumar Agarwal

 

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.


conditional formatting_indirectfunction.xls
Description: MS-Excel spreadsheet

RE: $$Excel-Macros$$ Conditional Formatting

[Ravinder]

pfa

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of anon
Sent: Wednesday, November 27, 2013 2:45 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Conditional Formatting

 

Attached.

On Tuesday, 26 November 2013 18:06:00 UTC, ashish wrote:

can u share a sample file

 

On Tue, Nov 26, 2013 at 11:19 PM, anon  > wrote:

Hi all,

 

Using conditional formatting, how can I highlight the smallest-valued cell
which is greater than 1.5?

 

Thanks.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to excel-macros...@googlegroups.com  .
To post to this group, send email to excel-...@googlegroups.com
 .
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.




-- 

Regards

 

Ashish Koul

 

 

Visit

http://www.excelvbamacros.in <http://www.excelvbamacros.in/> 

Like Us on Facebook
<http://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897> 

Join Us on Facebook <http://www.facebook.com/groups/163491717053198/> 

 

 

P Before printing, think about the environment.

 

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.


conditinal formating for minvalue_with criteria.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Conditional formatting

[Anil Gawli]

 Dear Fonbery,

Pl share the workbook with us.

Warm Regards,
Gawli Anil/.

On Thu, Jan 23, 2014 at 7:45 PM, Berinyuy Fonyuy  wrote:
> Dear reader, I got an excel sheet  of 44 indicators, with Health data that
> has been conditioned with a red pop up sign to show that the an indicator is
> not well recorded. Now I want to write a formulae that will help me in
> another area of the sheet to identify those health facilties haveing errors
> by identifying them an X and those with no errors by with a thick.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
> not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Conditional formatting

[Vaibhav Joshi]

whats issue?


On Mon, Jun 16, 2014 at 11:12 AM, N.Shivkumar  wrote:

> Dear friends
>
> Can anybody throw some light and help me as to where I am going wrong in
> conditional formatting!
>
>
>
>
>
>
>
>
>
> N.SHIVKUMAR
> Mobile : +919422613567
> Office  : +912332301775
> Alternate Email: shiv1...@yahoo.com
>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

RE: $$Excel-Macros$$ Conditional formatting

[Ravinder]

PFA, if you are looking for this.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of N.Shivkumar
Sent: Monday, June 16, 2014 11:13 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Conditional formatting

 

Dear friends

 

Can anybody throw some light and help me as to where I am going wrong in 
conditional formatting! 


 

 

 

 

 

   

 

   

    

 

N.SHIVKUMAR

Mobile : +919422613567
Office  : +912332301775
Alternate Email: shiv1...@yahoo.com

   

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


CONDTION FORMATING WITH %.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Conditional formatting

[N.Shivkumar]

Dear Vaibhavji
If the achievement is > 100% it should green arrow up, if it is less than
90% it should show red arrow down and if between 90 and 100 it should show
straight arrow.​










N.SHIVKUMAR
Mobile : +919422613567
Office  : +912332301775
Alternate Email: shiv1...@yahoo.com




On 16 June 2014 11:25, Vaibhav Joshi  wrote:

> whats issue?
>
>
> On Mon, Jun 16, 2014 at 11:12 AM, N.Shivkumar  wrote:
>
>> Dear friends
>>
>> Can anybody throw some light and help me as to where I am going wrong in
>> conditional formatting!
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> N.SHIVKUMAR
>> Mobile : +919422613567
>> Office  : +912332301775
>> Alternate Email: shiv1...@yahoo.com
>>
>>
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Conditional formatting

[N.Shivkumar]

Exactly and thanks for your reply ​











N.SHIVKUMAR
Mobile : +919422613567
Office  : +912332301775
Alternate Email: shiv1...@yahoo.com




On 16 June 2014 11:54, Ravinder  wrote:

> PFA, if you are looking for this.
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *N.Shivkumar
> *Sent:* Monday, June 16, 2014 11:13 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Conditional formatting
>
>
>
> Dear friends
>
>
>
> Can anybody throw some light and help me as to where I am going wrong in
> conditional formatting!
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> N.SHIVKUMAR
>
> Mobile : +919422613567
> Office  : +912332301775
> Alternate Email: shiv1...@yahoo.com
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ conditional formatting

[NOORAIN ANSARI]

Dear Deba,

See attached Sheet.

for Red you use..

=Hour($A1)>4

and for yellow

=Hour($A1)<4


-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com



On Wed, Jun 13, 2012 at 4:44 PM, Deba Ranjan  wrote:

> Dear Experts,
>
>I have attached a file which i need format conditional, i have tried
> many times, but fail to do so.
> My query is :- in K column, i want to format conditional, more then 4
> hours, red, and less then 4 hours yellow. (k cloumn consist formula, which
> was solved by Norrain bro).
>
>  Please solve
>
>
>
> Thanks & Regards,
> *Deba Ranjan P*
>
>
> 
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Copy of Time calculation(Deba).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ conditional formatting

[Deba Ranjan]

Thanks bro.. awesome. Thnks again


Thanks & Regards,
*Deba Ranjan P*





On Wed, Jun 13, 2012 at 4:49 PM, NOORAIN ANSARI wrote:

> Dear Deba,
>
> See attached Sheet.
>
> for Red you use..
>
> =Hour($A1)>4
>
> and for yellow
>
> =Hour($A1)<4
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
>
>
> On Wed, Jun 13, 2012 at 4:44 PM, Deba Ranjan  wrote:
>
>> Dear Experts,
>>
>>I have attached a file which i need format conditional, i have tried
>> many times, but fail to do so.
>> My query is :- in K column, i want to format conditional, more then 4
>> hours, red, and less then 4 hours yellow. (k cloumn consist formula, which
>> was solved by Norrain bro).
>>
>>  Please solve
>>
>>
>>
>> Thanks & Regards,
>> *Deba Ranjan P*
>>
>>
>> 
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

RE: $$Excel-Macros$$ conditional formatting

[Rajan_Verma]

See the attached file

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Deba Ranjan
Sent: 13 June 2012 4:45
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ conditional formatting

 

Dear Experts,

   I have attached a file which i need format conditional, i have tried many
times, but fail to do so.
My query is :- in K column, i want to format conditional, more then 4 hours,
red, and less then 4 hours yellow. (k cloumn consist formula, which was
solved by Norrain bro).

 Please solve 



 

Thanks & Regards,
Deba Ranjan P

 

 

-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Copy of Time calculation(Solved).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ conditional formatting

[Deba Ranjan]

Thanks rajan bro.


Thanks & Regards,
*Deba Ranjan P*





On Wed, Jun 13, 2012 at 6:41 PM, Rajan_Verma wrote:

> See the attached file
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Deba Ranjan
> *Sent:* 13 June 2012 4:45
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ conditional formatting
>
> ** **
>
> Dear Experts,
>
>I have attached a file which i need format conditional, i have tried
> many times, but fail to do so.
> My query is :- in K column, i want to format conditional, more then 4
> hours, red, and less then 4 hours yellow. (k cloumn consist formula, which
> was solved by Norrain bro).
>
>  Please solve
>
> 
>
>  
>
> Thanks & Regards,
> *Deba Ranjan P*
>
> ** **
>
> ** **
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Conditional Formatting

[ashish koul]

Great info... Thanks for sharing keep it up..

On Tue, Nov 9, 2010 at 7:01 PM, Rajasekhar Praharaju <
rajasekhar.prahar...@gmail.com> wrote:

> Conditional Formatting
>
>
>
> You can use something called Conditional Formatting in your spreadsheets.
> Conditional Formatting allows you to change the appearance of a cell,
> depending on certain conditions. What we'll do is to colour the Overall
> Averages on our Student Exam spreadsheet, depending on the grade. Here's the
> spreadsheet we'll be working on.
>
> [image: The Student Grades Spreadsheet]
>
>- Open up your Student Exam spreadsheet (You did complete it, didn't
>you?)
>- Highlight the cells with Overall Grades, which should be cells B11 to
>I11
>
> The Overall Averages range from 44 to 85. We'll colour each grade,
> depending on a scale. A different colour will apply to the following grades:
>
>- 50 and below
>- 51 to 60
>- 61 to 70
>- 71 to 80
>- 81 and above
>
> So five different bands, and a colour for each. To set the Conditional
> Formatting in Excel 2007, do the following:
>
>- With your Overall Averages highlighted, click on the Home menu at the
>top of Excel
>- Locate the *Styles* panel, and the *Conditional Formatting* item:
>
> [image: The Styles Panel in Excel 2007]
>
> The Conditional Formatting menu gives you various options. The easiest one
> is the Colour Scales option. Select one of these and Excel will colour the
> cell backgrounds for you:
>
> [image: Color Scales in Excel 2007]
>
> That's not quite what we're looking for, though. We'd like to choose our
> own values. So click on *More Rules*, from the *Colour Scales* submenu.
> You'll see the following rather complex dialogue box:
>
> [image: New Formatting Rule dialogue box]
>
> The one we want is the second option, *Format only cells that contain*.
> This will allow us to set up our values. When you click this option, the
> dialogue box changes to this:
>
> The part we're interested in is the bottom part, under the heading *Edit
> the Rule Description*. It says *Cell Value* and *Between*, in the drop
> down boxes. These are the ones we want. We only need to type a value for the
> two boxes that are currently blank in the image above. We can then click the
> *Format* button to choose a colour.
>
> So type 0 in the first box and 50 in the second one:
>
> Then click the *Format* button. You'll get another dialogue box popping
> up. This is just the Format Cells one though. You've met this before. Click
> on the Fill tab and choose a colour. Click OK and you should see something
> like this under Edit the Rule Description:
>
> The Preview is showing the colour we picked. So we've said, "*If* the Cell
> Value is between 0 and 50 *then* colour the cell Red".
>
> Click OK on this dialogue box to get back to Excel. You should find that
> one of the cells has turned red. To format the rest of the cells, click on
> Conditional Formatting on the Styles panel again. From the menu, click on
> *Manage Rules*:
>
> You'll get yet another complex dialogue box popping up! This one:
>
> Our first rule is already there - Cell Value Between. The only thing we're
> doing here is adding New Rules, similar to the one we've just set up. Click
> the *New Rule* button then. You'll see the exact same dialogue boxes you
> used to set up the first rule. Set a new colour for the next scores - 51 to
> 60. Choose a colour, and keep clicking OK until you get back to the Rules
> Manager dialogue box. It should now look something like this one:
>
> We now have to colours in our range. Do the rest of the scores, choosing a
> colour for each. The scores are these, remember:
>
>- 50 and below
>- 51 to 60
>- 61 to 70
>- 71 to 80
>- 81 and above
>
> When you've done them all, your dialogue box should have five colours:
>
> The colours above are entirely arbitrary, and you don't have to select the
> same ones we did. The point is to have a different colour for each range of
> scores. But click OK when you're done. Your Overall Averages will then look
> something like this:
>
> Formatting your spreadsheet in this way allows you to see at a glance
> relevant information. In the spreadsheet above, it's obvious who's failing -
> just look for the red cells!
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/1

Re: $$Excel-Macros$$ Conditional Formatting

[XLS S]

kindly put 3 condition it self and then send file.

try this code

Private Sub Worksheet_Change(ByVal Target As Range)
  Set I = Intersect(Target, Range("B2:B8"))
  If Not I Is Nothing Then
Select Case Target
  Case 0 To 100: NewColor = 37 ' light blue
  Case 101 To 200: NewColor = 46 ' orange
  Case 201 To 300: NewColor = 12 ' dark yellow
  Case 301 To 400: NewColor = 10 ' green
  Case 401 To 600: NewColor = 3 ' red
  Case 601 To 1000: NewColor = 20 ' lighter blue
End Select
Target.Interior.ColorIndex = NewColor
  End If
End Sub

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
  Range("F1:F1") = Range("F1:F1").Interior.ColorIndex
End Sub


On Thu, Aug 25, 2011 at 1:07 PM, Zafar Iqbal  wrote:

> Dear Excel Experts,
>
>
>
> I want graphical presentation of each employee's assignment duration in
> days with conditional formatting described in attached sheet.
>
> These color bars should move forward, backward, increase or decrease
> automatically when their duration is changed.
>
> In Excel - 2003, conditional formatting with only three options is
> possible. Here, I have four conditions i.e. Assign-1, 2, 3 and vacation.
>
> Please help me in preparing this sheet with automatic floating colors.
> Thanks in advance.
>
>
>
> Regards,
>
> ZAFAR IQBAL
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Conditional Formatting

[XLS S]

hey Zafar,

i think there is 5 condition...
1st  if  result is 1
2nd if result is 2
3rd if result is 3
4th  if  result is 0
and 5 is if On Leave

if is it ok then give the confirmation, then i start the  work


On Sat, Aug 27, 2011 at 12:59 PM, Zafar Iqbal  wrote:

> Dear Expert,
>
> Ref your instructions, please find attached file with conditional
> formatting applied. My worry is about 4th condition "On Leave". My
> conditional formatting gets failed when employee is "On Leave". This may
> occur anywhere in
> Assignment-1, 2 or 3.
> On Leave condition should be mentioned as "x" without any color.
> Color pattern should not be disturbed whenever "On Leave" condition is
> applied. Assignment-1 (Light Green), Assignement 2 - (Light Yellow) and
> assignment 3 with (Light Blue), always.
>
> Please help me in this problem with formula only.
>
> Thanks,
>
> Zafar Iqbal
>
> On Thu, Aug 25, 2011 at 2:17 PM, XLS S  wrote:
>
>> kindly put 3 condition it self and then send file.
>>
>> try this code
>>
>> Private Sub Worksheet_Change(ByVal Target As Range)
>>   Set I = Intersect(Target, Range("B2:B8"))
>>   If Not I Is Nothing Then
>> Select Case Target
>>   Case 0 To 100: NewColor = 37 ' light blue
>>   Case 101 To 200: NewColor = 46 ' orange
>>   Case 201 To 300: NewColor = 12 ' dark yellow
>>   Case 301 To 400: NewColor = 10 ' green
>>   Case 401 To 600: NewColor = 3 ' red
>>   Case 601 To 1000: NewColor = 20 ' lighter blue
>> End Select
>> Target.Interior.ColorIndex = NewColor
>>   End If
>> End Sub
>>
>> Private Sub Worksheet_SelectionChange(ByVal Target As Range)
>>   Range("F1:F1") = Range("F1:F1").Interior.ColorIndex
>> End Sub
>>
>>
>>
>> On Thu, Aug 25, 2011 at 1:07 PM, Zafar Iqbal  wrote:
>>
>>>  Dear Excel Experts,
>>>
>>>
>>>
>>> I want graphical presentation of each employee's assignment duration in
>>> days with conditional formatting described in attached sheet.
>>>
>>> These color bars should move forward, backward, increase or decrease
>>> automatically when their duration is changed.
>>>
>>> In Excel - 2003, conditional formatting with only three options is
>>> possible. Here, I have four conditions i.e. Assign-1, 2, 3 and vacation.
>>>
>>> Please help me in preparing this sheet with automatic floating colors.
>>> Thanks in advance.
>>>
>>>
>>>
>>> Regards,
>>>
>>> ZAFAR IQBAL
>>>
>>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Conditional Formatting

[Zafar Iqbal]

Dear Expert,

One last thing to remind that Color bar should increase or decrease when
duration is changed. Please help in this matter with Excel logical formulas
& conditional formatting, only. Try to avoid VBA, if possible. Thanks

Regards,
Zafar Iqbal

On Mon, Aug 29, 2011 at 11:03 AM, Zafar Iqbal  wrote:

>  Dear Expert,
>
> Thanks for sparing time for my question. You are right in indicating five
> conditions.
>
> Case   Result  Cell Color
> Condition-1 0  NoIf Dur1,2,3 is Zero or blank
> Condition-2 1  Green   If Dur1>0
> Condition-3 2  Yellow  If Dur2>0
> Condition-4 3  Blue If Dur3>0
> Condition-5 x  No   If WO1,2,3 = On Leave
> I shall be very thankful to you for this great help to solve this problem.
>
> Regards,
>
> Zafar Iqbal
> -
>
> On Sun, Aug 28, 2011 at 8:36 PM, XLS S  wrote:
>
>> hey Zafar,
>>
>> i think there is 5 condition...
>> 1st  if  result is 1
>> 2nd if result is 2
>> 3rd if result is 3
>> 4th  if  result is 0
>> and 5 is if On Leave
>>
>> if is it ok then give the confirmation, then i start the  work
>
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ conditional formatting

[Manoj Kumar]

Dear Smitha,

Please find the attachment..

it will help you...

Regard
Manoj

On Thu, Jul 26, 2012 at 11:44 AM, Smitha S R  wrote:

> Hi,
>
> Please help in conditional formatting or use of if formula in the
> following case. Excel attached.
>
>   Closing Stock Verification stock required  1 1 if closing
> Stock=Verification Stock blue colour should be filled in cell B3  5 4 if
> closing Stock>Verification Stock  green colour should be filled in cell B4
> 3 5 if closing Stock in cell B5
>
> --
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com




fill colour.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ conditional formatting

[Kuldeep Singh]

Dear Smitha,

Please try this. (Sheet - 1 & Sheet - 2)

Regards,
Kuldeep Singh
Phone.: +91-120-4763789, Extn.: 789
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this e-mail unless
you really need to.*

On Thu, Jul 26, 2012 at 11:44 AM, Smitha S R  wrote:

> Hi,
>
> Please help in conditional formatting or use of if formula in the
> following case. Excel attached.
>
>   Closing Stock Verification stock required  1 1 if closing
> Stock=Verification Stock blue colour should be filled in cell B3  5 4 if
> closing Stock>Verification Stock  green colour should be filled in cell B4
> 3 5 if closing Stock in cell B5
>
> --
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com




Conditional Formatting Queryxlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ conditional formatting

[Smitha S R]

Hi,
If one cell value is a specific text like "On", the whole row from A2 to D2
should be filled with yellow colour. How can it be?

On Thu, Jul 26, 2012 at 12:25 PM, Kuldeep Singh wrote:

>
> Dear Smitha,
>
> Please try this. (Sheet - 1 & Sheet - 2)
>
> Regards,
> Kuldeep Singh
> Phone.: +91-120-4763789, Extn.: 789
> naukrikuld...@gmail.com || www.naukri.com
> *Please* *Consider the environment. Please don't print this e-mail unless
> you really need to.*
>
> On Thu, Jul 26, 2012 at 11:44 AM, Smitha S R  wrote:
>
>> Hi,
>>
>> Please help in conditional formatting or use of if formula in the
>> following case. Excel attached.
>>
>>   Closing Stock Verification stock required  1 1 if closing
>> Stock=Verification Stock blue colour should be filled in cell B3  5 4 if
>> closing Stock>Verification Stock  green colour should be filled in cell
>> B4  3 5 if closing Stock> filled in cell B5
>>
>> --
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>  --
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ conditional formatting

[Smitha S R]

HI,

some one please help me on this.

On Mon, Aug 20, 2012 at 12:20 PM, Smitha S R  wrote:

> Hi,
>
> If one cell contain a specific Text "On", the whole row from A2 to D2
> should be filled with yellow colour.  How can it be?
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ conditional formatting

[ashish koul]

select range a2:d2 then use
=COUNTIF($A$2:$D$2,"ok")>=1




[image: Inline image 1]



On Mon, Aug 20, 2012 at 12:36 PM, Smitha S R  wrote:

> HI,
>
> some one please help me on this.
>
> On Mon, Aug 20, 2012 at 12:20 PM, Smitha S R  wrote:
>
>> Hi,
>>
>> If one cell contain a specific Text "On", the whole row from A2 to D2
>> should be filled with yellow colour.  How can it be?
>>
>> --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>>
>>
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
*Regards*
* *
*Ashish Koul*


*Visit*
*http://www.excelvbamacros.com/*
*http://www.accessvbamacros.com/*

P Before printing, think about the environment.

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.


<>

Re: $$Excel-Macros$$ conditional formatting

[Smitha S R]

Hi Ashish,
I apply the said formula, its counting 'Not Ok" also and filling the same
colour.

On Mon, Aug 20, 2012 at 12:40 PM, ashish koul  wrote:

>
>
> select range a2:d2 then use
> =COUNTIF($A$2:$D$2,"ok")>=1
>
>
>
>
> [image: Inline image 1]
>
>
>
> On Mon, Aug 20, 2012 at 12:36 PM, Smitha S R  wrote:
>
>> HI,
>>
>> some one please help me on this.
>>
>> On Mon, Aug 20, 2012 at 12:20 PM, Smitha S R wrote:
>>
>>> Hi,
>>>
>>> If one cell contain a specific Text "On", the whole row from A2 to D2
>>> should be filled with yellow colour.  How can it be?
>>>
>>> --
>>> Join official facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES (1120+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> 6) Jobs posting is not allowed.
>>>
>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>>
>>>
>>>
>>
>>  --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>>
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
>
>
> *Visit*
> *http://www.excelvbamacros.com/*
> *http://www.accessvbamacros.com/*
>
> P Before printing, think about the environment.
>
>
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

Re: $$Excel-Macros$$ conditional formatting

[Smitha S R]

please help me

On Mon, Aug 20, 2012 at 1:59 PM, Smitha S R  wrote:

> Hi Ashish,
> I apply the said formula, its counting 'Not Ok" also and filling the same
> colour.
>
>
> On Mon, Aug 20, 2012 at 12:40 PM, ashish koul wrote:
>
>>
>>
>> select range a2:d2 then use
>> =COUNTIF($A$2:$D$2,"ok")>=1
>>
>>
>>
>>
>> [image: Inline image 1]
>>
>>
>>
>> On Mon, Aug 20, 2012 at 12:36 PM, Smitha S R wrote:
>>
>>> HI,
>>>
>>> some one please help me on this.
>>>
>>> On Mon, Aug 20, 2012 at 12:20 PM, Smitha S R wrote:
>>>
 Hi,

 If one cell contain a specific Text "On", the whole row from A2 to D2
 should be filled with yellow colour.  How can it be?

 --
 Join official facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES (1120+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 6) Jobs posting is not allowed.

 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups "MS EXCEL AND VBA MACROS" group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.



>>>
>>>  --
>>> Join official facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES (1120+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> 6) Jobs posting is not allowed.
>>>
>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>>
>>>
>>>
>>
>>
>>
>> --
>> *Regards*
>> * *
>> *Ashish Koul*
>>
>>
>> *Visit*
>> *http://www.excelvbamacros.com/*
>> *http://www.accessvbamacros.com/*
>>
>> P Before printing, think about the environment.
>>
>>
>>
>>  --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>>
>>
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
qui

RE: $$Excel-Macros$$ conditional formatting

[Amit Desai (MERU)]

Dear Pravin,

Could you please explain, how did you put the conditional formatting in all the 
cells together?

Best Regards,
Amit

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Pravin Gunjal
Sent: 21 August 2012 18:56
To: sperdwo...@gmail.com; excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ conditional formatting

Hi Smitha

Pl try this...


With regards,
Pravin Gunjal


-- Forwarded message --
From: Smitha S R mailto:sperdwo...@gmail.com>>
Date: Mon, Aug 20, 2012 at 4:59 PM
Subject: Re: $$Excel-Macros$$ conditional formatting
To: excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>


The colour should be filled in the whole row, not only in the cell.
The way suggested fill the colour in the cell only.
--
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited.

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to 
excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com<mailto:excel-macros+unsubscr...@googlegroups.com>.




Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ conditional formatting

[NOORAIN ANSARI]

Dear Amit,

Create a simple Conditional formating rule and Manage it for Whole rows.
Hilary Screen shot is nicely describing it.

On Tue, Aug 21, 2012 at 7:30 PM, Amit Desai (MERU)
wrote:

>  Dear Pravin,
>
> ** **
>
> Could you please explain, how did you put the conditional formatting in
> all the cells together?
>
> ** **
>
> Best Regards,
>
> Amit
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Pravin Gunjal
> *Sent:* 21 August 2012 18:56
> *To:* sperdwo...@gmail.com; excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ conditional formatting
>
> ** **
>
> *Hi Smitha*
>
> ** **
>
> *Pl try this...*
>
> * *
>
> *With regards,
> **Pravin Gunjal*
>
> ** **
>
> -- Forwarded message ------
> From: *Smitha S R* 
> Date: Mon, Aug 20, 2012 at 4:59 PM
> Subject: Re: $$Excel-Macros$$ conditional formatting
> To: excel-macros@googlegroups.com
>
>
> The colour should be filled in the whole row, not only in the cell.
> The way suggested fill the colour in the cell only.
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>  
>
> --
> Disclaimer: This message and its attachments contain confidential
> information and may also contain legally privileged information. This
> message is intended solely for the named addressee. If you are not the
> addressee indicated in this message (or authorized to receive for
> addressee), you may not copy or deliver any part of this message or its
> attachments to anyone or use any part of this message or its attachments.
> Rather, you should permanently delete this message and its attachments (and
> all copies) from your system and kindly notify the sender by reply e-mail.
> Any content of this message and its attachments that does not relate to the
> official business of Meru Cab Company Pvt. Ltd. must be taken not to have
> been sent or endorsed by any of them. Email communications are not private
> and no warranty is made that e-mail communications are timely, secure or
> free from computer virus or other defect.
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
With Regards,
Noorain Ansari
http:// 
<http://www.noorainansari.co

Re: $$Excel-Macros$$ Conditional formatting

[ashish koul]

check the attachment



On Fri, Nov 9, 2012 at 9:55 PM, Shiva Prasad wrote:

> Dear Champs,
>
> i have on excel one sheet  when i mentioned values of percentages change
> the color of that cells.
>
> please help me the formula r any macro also.
>
> plz find the attchement of example of trail sheet.
>
> plz need .
>
> --
>
>
>
>
>
> Regards,
> Shivaprasad K.
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>



-- 
*Regards*
* *
*Ashish Koul*


*Visit*
*http://www.excelvbamacros.com/*
*http://www.accessvbamacros.com/*

P Before printing, think about the environment.

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.




Trail sheet.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Conditional formatting

[Ayush Jain]

Hi Shiv

You can use conditional formatting to color the cells(or any other
formatting) based on the value of the cell. I have implemented the same in
the enclosed file.
Let us know if you need any further assistance on this.

Regards
Ayush Jain


On Fri, Nov 9, 2012 at 9:55 PM, Shiva Prasad wrote:

> Dear Champs,
>
> i have on excel one sheet  when i mentioned values of percentages change
> the color of that cells.
>
> please help me the formula r any macro also.
>
> plz find the attchement of example of trail sheet.
>
> plz need .
>
> --
>
>
>
>
>
> Regards,
> Shivaprasad K.
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>



-- 
Best regards,
Ayush Jain

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.




Trail sheet.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Conditional formatting

[>>Excel Beginner<]

Hi shiva,

   please find the attachment.




-- 
*Regards,*
*
*
*Excel Beginner*
*
*
On Fri, Nov 9, 2012 at 9:55 PM, Shiva Prasad wrote:

> Dear Champs,
>
> i have on excel one sheet  when i mentioned values of percentages change
> the color of that cells.
>
> please help me the formula r any macro also.
>
> plz find the attchement of example of trail sheet.
>
> plz need .
>
> --
>
>
>
>
>
> Regards,
> Shivaprasad K.
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.




Trail sheet (Solved).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Conditional formatting

[Aamir Shahzad]

Please see the attached sheet

Aamir Shahzad

On Fri, Nov 9, 2012 at 9:59 PM, >>Excel Beginner<<
wrote:

> Hi shiva,
>
>please find the attachment.
>
>
>
>
> --
> *Regards,*
> *
> *
> *Excel Beginner*
> *
> *
> On Fri, Nov 9, 2012 at 9:55 PM, Shiva Prasad wrote:
>
>> Dear Champs,
>>
>> i have on excel one sheet  when i mentioned values of percentages change
>> the color of that cells.
>>
>> please help me the formula r any macro also.
>>
>> plz find the attchement of example of trail sheet.
>>
>> plz need .
>>
>> --
>>
>>
>>
>>
>>
>> Regards,
>> Shivaprasad K.
>> --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>
>>
>>
>
>
>
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>



-- 

Regards,
Aamir Shahzad

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.




Trail sheet.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Conditional Formatting

[amar takale]

Hi Annop,

Good Solution.But If there are Constant number both cell then I want
Neutral arrow,can it possible?
Regards Amar

On Wed, Dec 5, 2012 at 11:35 AM, Anoop K Sharma wrote:

> Please find attached. I hope this can help you.
>
> Regards,
> Anoop
> Sr. Developer
>
>
> On Wed, Dec 5, 2012 at 12:54 AM, JP  wrote:
>
>> Hi -
>>
>> I have a spreadsheet in which I have the following formula for
>> statistical testing, =IF(L7>=$S$2,CHAR(233),IF(L7<=-$S$2,CHAR(234),"")). It
>> displays an up arrow if the first IF statement is true and an down arrow if
>> the second IF statement is true.  I would like the arrow displayed to be
>> bolded and if it is an up arrow then it should be in green font and if the
>> arrow is downward then it should be in red font.  How would I add the color
>> code to the existing formula so the arrows are displayed in color?
>>
>> Thanks,
>> JP
>>
>> --
>> Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>
>>
>>
>
>
>
> --
> Regards,
> Anoop
> Sr. Developer
>
>  --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ Conditional Formatting

[Anoop K Sharma]

Use the following one

=IF(B2>$A$2,"↓",IF(B2<$A$2,"↑","↕"))


On Fri, Dec 7, 2012 at 12:37 PM, amar takale  wrote:

> Hi Annop,
>
> Good Solution.But If there are Constant number both cell then I want
> Neutral arrow,can it possible?
> Regards Amar
>
>
> On Wed, Dec 5, 2012 at 11:35 AM, Anoop K Sharma wrote:
>
>> Please find attached. I hope this can help you.
>>
>> Regards,
>> Anoop
>> Sr. Developer
>>
>>
>> On Wed, Dec 5, 2012 at 12:54 AM, JP  wrote:
>>
>>> Hi -
>>>
>>> I have a spreadsheet in which I have the following formula for
>>> statistical testing, =IF(L7>=$S$2,CHAR(233),IF(L7<=-$S$2,CHAR(234),"")). It
>>> displays an up arrow if the first IF statement is true and an down arrow if
>>> the second IF statement is true.  I would like the arrow displayed to be
>>> bolded and if it is an up arrow then it should be in green font and if the
>>> arrow is downward then it should be in red font.  How would I add the color
>>> code to the existing formula so the arrows are displayed in color?
>>>
>>> Thanks,
>>> JP
>>>
>>> --
>>> Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>>
>>>
>>>
>>
>>
>>
>> --
>> Regards,
>> Anoop
>> Sr. Developer
>>
>>  --
>> Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>
>>
>>
>
>  --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>



-- 
Regards,
Anoop
Sr. Developer

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is n

Re: $$Excel-Macros$$ Conditional Formatting

[amar takale]

Hi Anoop
Thanks very much for solution but I want neutral arrow is horizontal not
vertical.

On Fri, Dec 7, 2012 at 12:56 PM, Anoop K Sharma wrote:

> =IF(B2>$A$2,"↓",IF(B2<$A$2,"↑","↕"))
>

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ Conditional Formatting

[Anoop K Sharma]

Hi Amar,

Is this you want?
=IF(B2>$A$2,"↓",IF(B2<$A$2,"↑","↔"))

You can go to insert symbol section where you can put all of your choice
available there.

Regards,
Anoop
Sr. Developer


On Sat, Dec 8, 2012 at 10:23 AM, amar takale  wrote:

> Hi Anoop
> Thanks very much for solution but I want neutral arrow is horizontal not
> vertical.
>
> On Fri, Dec 7, 2012 at 12:56 PM, Anoop K Sharma wrote:
>
>> =IF(B2>$A$2,"↓",IF(B2<$A$2,"↑","↕"))
>>
>
>  --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>



-- 
Regards,
Anoop
Sr. Developer

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ Conditional Formatting

[amar takale]

Dear Anoop,
Thanks great,Exactly I want.I try this many time but not successful how to
extract arrow (Neutral) where it is in excel in symbol I got but it is half
arrow then I use it two half arrow with merge with concatenate which is use
in attached sheet.But now you send me perfect arrow if it is little big
then look attractive bcos which you give it is so small.
Pls see file
Regards
Amar

On Mon, Dec 10, 2012 at 8:11 AM, Anoop K Sharma wrote:

> Hi Amar,
>
> Is this you want?
>
> =IF(B2>$A$2,"↓",IF(B2<$A$2,"↑","↔"))
>
> You can go to insert symbol section where you can put all of your choice
> available there.
>
> Regards,
> Anoop
> Sr. Developer
>
>
> On Sat, Dec 8, 2012 at 10:23 AM, amar takale  wrote:
>
>> Hi Anoop
>> Thanks very much for solution but I want neutral arrow is horizontal not
>> vertical.
>>
>> On Fri, Dec 7, 2012 at 12:56 PM, Anoop K Sharma 
>> wrote:
>>
>>> =IF(B2>$A$2,"↓",IF(B2<$A$2,"↑","↕"))
>>>
>>
>>  --
>> Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>
>>
>>
>
>
>
> --
> Regards,
> Anoop
> Sr. Developer
>
>  --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.




Arrow Excel.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Conditional Formatting

[Zafar Iqbal]

Dear Experts,

Still waiting for your kind response.

Regards,
Zafar Iqbal
-
On Mon, Aug 29, 2011 at 12:59 PM, Zafar Iqbal  wrote:

>  Dear Expert,
>
> One last thing to remind that Color bar should increase or decrease when
> duration is changed. Please help in this matter with Excel logical formulas
> & conditional formatting, only. Try to avoid VBA, if possible. Thanks
>
> Regards,
> Zafar Iqbal
> 
>   On Mon, Aug 29, 2011 at 11:03 AM, Zafar Iqbal wrote:
>
>>  Dear Expert,
>>
>> Thanks for sparing time for my question. You are right in indicating five
>> conditions.
>>
>> Case   Result  Cell Color
>> Condition-1 0  NoIf Dur1,2,3 is Zero or blank
>> Condition-2 1  Green   If Dur1>0
>> Condition-3 2  Yellow  If Dur2>0
>> Condition-4 3  Blue If Dur3>0
>> Condition-5 x  No   If WO1,2,3 = On Leave
>> I shall be very thankful to you for this great help to solve this problem.
>>
>> Regards,
>>
>> Zafar Iqbal
>> -
>>
>> On Sun, Aug 28, 2011 at 8:36 PM, XLS S  wrote:
>>
>>> hey Zafar,
>>>
>>> i think there is 5 condition...
>>> 1st  if  result is 1
>>> 2nd if result is 2
>>> 3rd if result is 3
>>> 4th  if  result is 0
>>> and 5 is if On Leave
>>>
>>> if is it ok then give the confirmation, then i start the  work
>>
>>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Conditional Formatting

[Zafar Iqbal]

Dear Experts,

Will somebody inform me that why my request is not getting your kind
attention, please?

Regards,
Zafar Iqbal

On Mon, Sep 5, 2011 at 11:00 AM, Zafar Iqbal  wrote:

>  Dear Experts,
>
> Still waiting for your kind support.
>
> Regards,
> Zafar Iqbal
> 
>   On Sun, Sep 4, 2011 at 8:11 AM, Zafar Iqbal  wrote:
>
>>  Dear Experts,
>>
>> Still waiting for your kind response.
>>
>> Regards,
>> Zafar Iqbal
>> -
>>   On Mon, Aug 29, 2011 at 12:59 PM, Zafar Iqbal wrote:
>>
>>>  Dear Expert,
>>>
>>> One last thing to remind that Color bar should increase or decrease when
>>> duration is changed. Please help in this matter with Excel logical formulas
>>> & conditional formatting, only. Try to avoid VBA, if possible. Thanks
>>>
>>> Regards,
>>> Zafar Iqbal
>>> 
>>>   On Mon, Aug 29, 2011 at 11:03 AM, Zafar Iqbal wrote:
>>>
  Dear Expert,

 Thanks for sparing time for my question. You are right in indicating
 five conditions.

 Case   Result  Cell Color
 Condition-1 0  NoIf Dur1,2,3 is Zero or blank
 Condition-2 1  Green   If Dur1>0
 Condition-3 2  Yellow  If Dur2>0
 Condition-4 3  Blue If Dur3>0
 Condition-5 x  No   If WO1,2,3 = On Leave
 I shall be very thankful to you for this great help to solve this
 problem.

 Regards,

 Zafar Iqbal
 -

>>>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Conditional Formatting

[dguillett1]

Perhaps because you said to avoid vba. What excel version. Perhaps a sample 
file.

From: Zafar Iqbal 
Sent: Tuesday, September 06, 2011 2:58 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Conditional Formatting

Dear Experts,

Will somebody inform me that why my request is not getting your kind attention, 
please?

Regards,
Zafar Iqbal


On Mon, Sep 5, 2011 at 11:00 AM, Zafar Iqbal  wrote:

  Dear Experts,

  Still waiting for your kind support.

  Regards,
  Zafar Iqbal
  

  On Sun, Sep 4, 2011 at 8:11 AM, Zafar Iqbal  wrote:

Dear Experts,

Still waiting for your kind response. 

Regards,
Zafar Iqbal
-

On Mon, Aug 29, 2011 at 12:59 PM, Zafar Iqbal  wrote:

  Dear Expert,

  One last thing to remind that Color bar should increase or decrease when 
duration is changed. Please help in this matter with Excel logical formulas & 
conditional formatting, only. Try to avoid VBA, if possible. Thanks

  Regards,
  Zafar Iqbal
  

  On Mon, Aug 29, 2011 at 11:03 AM, Zafar Iqbal  wrote:

Dear Expert,

Thanks for sparing time for my question. You are right in indicating 
five conditions. 

Case   Result  Cell Color 
Condition-1 0  NoIf Dur1,2,3 is Zero or blank
Condition-2 1  Green   If Dur1>0
Condition-3 2  Yellow  If Dur2>0
Condition-4 3  Blue If Dur3>0
Condition-5 x  No   If WO1,2,3 = On Leave

I shall be very thankful to you for this great help to solve this 
problem.

Regards,

Zafar Iqbal
-
-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Conditional Formatting

[§»VIPER«§]

hi prasad

pfa



On Fri, Oct 14, 2011 at 11:11 AM, Mr Excellent wrote:

> Hi Group,
>
> Need  a help in Conditional formatting
>
> I have 12 Columns in the sheet the first 6 Cols have the data and the next
> 6 Cols have the Checks, so based on the Values of "Yes" and "No for the
> Check1 to till Check6 the values in the first 6 Columns should be
> highlighted
>
> If It has "Yes" in the first Check1 then the First Column " S.no1" Shud be
> Red or else unformatted.
>
> Can anyone do this
>
> Thanks
> Prasad
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Great day,*
*viper*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Cond(1).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Conditional formatting

[Aivi]

Pls find attached file.

On Sat, Feb 18, 2012 at 12:38 PM, PRAVESH KUMAR wrote:

> HI,
>
>
> Please help...for conditional formatting
>
>
> PFA attached file
>
>
>
>
> Thanks
>
> Pravesh Kashyap
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
*Thanks & Regards
*
*Aivran kumar
*E-mail:- aivran...@gmail.com
http://facebook.aivik1

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Question(1).xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Conditional formatting

[Lakshman Prasad]

Plz see the attached 
 
 
 



From: PRAVESH KUMAR 
To: excel-macros@googlegroups.com 
Sent: Saturday, 18 February 2012 12:38 PM
Subject: $$Excel-Macros$$ Conditional formatting


HI,


Please help...for conditional formatting


PFA attached file




Thanks

Pravesh Kashyap
-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Question(1).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Conditional formatting

[PRAVESH KUMAR]

Hi,



Please Help.

On Sat, Feb 18, 2012 at 12:38 PM, PRAVESH KUMAR wrote:

> HI,
>
>
> Please help...for conditional formatting
>
>
> PFA attached file
>
>
>
>
> Thanks
>
> Pravesh Kashyap
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Conditional formatting

[Excel_Lover]

Dear,

Hope you are stuck in blank cells formatting, this can be done as follows,

In Excel 2007,

Conditional formatting => Highlight Cell Rules => Equal to, type
formula =""(not just "")


On Sun, Feb 19, 2012 at 4:41 PM, PRAVESH KUMAR wrote:

> Hi,
>
>
>
> Please Help.
>
> On Sat, Feb 18, 2012 at 12:38 PM, PRAVESH KUMAR 
> wrote:
>
>> HI,
>>
>>
>> Please help...for conditional formatting
>>
>>
>> PFA attached file
>>
>>
>>
>>
>> Thanks
>>
>> Pravesh Kashyap
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Conditional formatting

[Excel_Lover]

Sorry,The formula should be =" " (with a space) like this, as there is
formulas in your sheet.

On Sun, Feb 19, 2012 at 9:08 PM, Excel_Lover  wrote:

> Dear,
>
> Hope you are stuck in blank cells formatting, this can be done as follows,
>
> In Excel 2007,
>
> Conditional formatting => Highlight Cell Rules => Equal to, type formula
> ="" (not just "")
>
>
> On Sun, Feb 19, 2012 at 4:41 PM, PRAVESH KUMAR 
> wrote:
>
>> Hi,
>>
>>
>>
>> Please Help.
>>
>> On Sat, Feb 18, 2012 at 12:38 PM, PRAVESH KUMAR > > wrote:
>>
>>> HI,
>>>
>>>
>>> Please help...for conditional formatting
>>>
>>>
>>> PFA attached file
>>>
>>>
>>>
>>>
>>> Thanks
>>>
>>> Pravesh Kashyap
>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Conditional formatting issue

[sourav devrani]

PFA

On Wed, Mar 7, 2018 at 5:08 PM, vikas khen  wrote:

> Hi All,
>
> Request all of you to kindly help me on the attached sheet.
>
>
> I need conditional formatting for based on following two conditions
>
> 1) If the Actual date is less than or equal to Projected date it should
> highlighted in Green color
>
> and
> 2) If the Actual date is Greater than Projected date it should highlighted
> in Red Color
>
> Yor help in this regards will be highly appreciated.
>
> Thanks
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Conditional formating.xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ Conditional formatting issue

[vikas khen]

Thanks Sourav for your help.

On Wed, Mar 7, 2018 at 8:05 PM, sourav devrani 
wrote:

> PFA
>
> On Wed, Mar 7, 2018 at 5:08 PM, vikas khen  wrote:
>
>> Hi All,
>>
>> Request all of you to kindly help me on the attached sheet.
>>
>>
>> I need conditional formatting for based on following two conditions
>>
>> 1) If the Actual date is less than or equal to Projected date it should
>> highlighted in Green color
>>
>> and
>> 2) If the Actual date is Greater than Projected date it should
>> highlighted in Red Color
>>
>> Yor help in this regards will be highly appreciated.
>>
>> Thanks
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at https://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Conditional Formatting by Group

[ashish koul]

you can use this formula to identify duplicates
=IF(COUNTIFS($G$1:G2,G2,$H$1:H2,H2)=1,"","Duplicate")



On Thu, Jan 16, 2014 at 2:05 AM, JCraig  wrote:

> Hello Forum.
> I use this forum extensively for review and research yet I have never
> submitted a question before so hopefully someone may be able to help me
> figure this conundrum out .
>
> I spent several hours researching and trying to figure out how to
> conditionally format my file to highlight duplicate data within sets of
> data within the sheet rather than within the (whole) sheet itself. I cannot
> find reference to application functionality which supports this so I think
> it may be a custom VBA thing; to which I have little experience with.
>
> Although my file consists of approx 20,000 records I have included my
> excel sheet of data show what it is I am trying to accomplish. My file
> consists of (and sorted by) unique course numbers (col H) to corresponding
> descriptions (col G); a one to many relationship unique course# to
> several possible descriptions.
>
> I would like to highlight descriptions if they are duplicates, but only by
> course number groups. So the VBA would look at the range of unique records
> in column H (course#) and highlight all column G records (course
> description) if column G records are duplicates. When the course number
> changes; repeat. Make sense?
>
> My intent is to be able to sort out the duplicates so I am left with only
> the non-duplicates for review. Otherwise I have to look at each record in
> my file to determine if an update is needed; yikes!
>
> Again, thanks for reading and helping if you can.
>
> J
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>



-- 
*Regards*

*Ashish Koul*


*Visit*
http://www.excelvbamacros.in
Like Us on 
Facebook
Join Us on Facebook 


P Before printing, think about the environment.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

RE: $$Excel-Macros$$ Conditional formatting Excel 2002

[Dave Bonallack]

Hi Keith,
You can force the upper-case by using the 'UCase' VBA function on the 'Target'
You can then remove the lower-case Cases.

Private Sub Worksheet_Change(ByVal Target As Range)
Set I = Intersect(Target, 
Range("I9:AM58,I66:AM115,I124:AM173,I182:AM231,I240:AM289"))
If Not I Is Nothing Then
Select Case UCase(Target)
Case "V": NewColor = 3
Case "E": NewColor = 33
Case "M": NewColor = 36
Case "S": NewColor = 4
End Select
Target.Interior.ColorIndex = NewColor
End If
End Sub

A simple way to allow mass deletions is to insert an error handling line:
On Error Resume Next
This effectively ignores errors, which seems to work for us in this case.
Try this with mass deletions:

Private Sub Worksheet_Change(ByVal Target As Range)
On Error Resume Next
Set I = Intersect(Target, 
Range("I9:AM58,I66:AM115,I124:AM173,I182:AM231,I240:AM289"))
If Not I Is Nothing Then
Select Case UCase(Target)
Case "V": NewColor = 3
Case "E": NewColor = 33
Case "M": NewColor = 36
Case "S": NewColor = 4
End Select
Target.Interior.ColorIndex = NewColor
End If
End Sub

Hope this helps.
Regards - Dave.


> Date: Sun, 14 Feb 2010 18:41:40 -0800
> Subject: $$Excel-Macros$$ Conditional formatting Excel 2002
> From: dkb...@gmail.com
> To: excel-macros@googlegroups.com
> 
> I consider myself a self-taught novice user of VBA for Excel.  I took
> on a project at work and developed this VBA code with the help of the
> internet to format the background color of this range.  Is there a way
> to force the uppercase version of the letters v, e, s and m if typed
> in lower case and still keep the background color for that cell?  And
> a final question, is there a way to incorporate a command button to
> delete only the text and background color and still leave the border
> untouched in each cell within this range at the beginning of a new
> month?  I can delete but I have to delete one cell at a time; if I
> select several cells at a time and push delete I get an error message
> highlighting "Case "v"" in yellow in the VB editor.
> 
> Any help is greatly appreciated.
> 
> Private Sub Worksheet_Change(ByVal Target As Range)
> Set I = Intersect(Target,
> Range("I9:AM58,I66:AM115,I124:AM173,I182:AM231,I240:AM289"))
> If Not I Is Nothing Then
> Select Case Target
> Case "v": NewColor = 3
> Case "V": NewColor = 3
> Case "e": NewColor = 33
> Case "E": NewColor = 33
> Case "m": NewColor = 36
> Case "M": NewColor = 36
> Case "s": NewColor = 4
> Case "S": NewColor = 4
> End Select
> Target.Interior.ColorIndex = NewColor
> End If
> 
> End Sub
> 
> Keith
> dkb...@gmail.com
> 
> -- 
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links : 
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @ 
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>  
> To post to this group, send email to excel-macros@googlegroups.com
> 
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
> 
> We reach over 6,800 subscribers worldwide and receive many nice notes about 
> the learning and support from the group.Let friends and co-workers know they 
> can subscribe to group at 
> http://groups.google.com/group/excel-macros/subscribe
  
_
Link all your email accounts and social updates with Hotmail. Find out now
http://windowslive.ninemsn.com.au/oneinbox?ocid=T162MSN05A0710G

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Conditional Formatting Excel 2007

[XLS S]

Hey ,

Please send the attachment...

try the below link

http://www.contextures.com/xlcondformat02.html
http://www.wikihow.com/Apply-Conditional-Formatting-in-Excel

On Wed, Sep 7, 2011 at 1:30 PM, zp18  wrote:

> A1=the name of an employee, defined name is "Suspect"
> A2= an amount of money, defined as "MaxLoss"
> B1:B8 is a column of money defined as "Shortages"
> C1:G8 is a range of employee names defined as "Associates"
>
>
> if the money contained in MaxLoss is less than the amount in column of
> Shortages and the "Suspect"'s name is contained in the Associates
> range then do something(bold, red, flashing etc)
>
>
> The intent is to match an employees name to shortages using
> conditional formatting
>
> James$57.20 Grace   Ronnie  MernalynIrene   0
> -50  $4.91  Julie   Jocelyn Tiffany
> RyanMark
> $22.50 Grace   Ronnie  James   Irene   Mernalyn
> $(0.78)Julie   Tiffany RyanMark
>0
> $50.06 Grace   James   MernalynIrene   0
> $2.65  Julie   Tiffany RyanMark0
> $24.28 Grace   0  00
> 0
> $(373.20)  Julie   Jocelyn Ryan0
> 0
>
> What should the statement be?  I cannot get the hang of logical
> operators in conditional formatting, any help would be appreciated.
>
> TIA
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Conditional Formatting Excel 2007

[Venkat CV]

Hi ,

See Below Links...
http://www.contextures.com/xlcondformat03.html\
http://www.dummies.com/how-to/content/applying-conditional-formatting-in-excel-2007.html

*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile *
*
*

On Wed, Sep 7, 2011 at 1:30 PM, zp18  wrote:

> A1=the name of an employee, defined name is "Suspect"
> A2= an amount of money, defined as "MaxLoss"
> B1:B8 is a column of money defined as "Shortages"
> C1:G8 is a range of employee names defined as "Associates"
>
>
> if the money contained in MaxLoss is less than the amount in column of
> Shortages and the "Suspect"'s name is contained in the Associates
> range then do something(bold, red, flashing etc)
>
>
> The intent is to match an employees name to shortages using
> conditional formatting
>
> James$57.20 Grace   Ronnie  MernalynIrene   0
> -50  $4.91  Julie   Jocelyn Tiffany
> RyanMark
> $22.50 Grace   Ronnie  James   Irene   Mernalyn
> $(0.78)Julie   Tiffany RyanMark
>0
> $50.06 Grace   James   MernalynIrene   0
> $2.65  Julie   Tiffany RyanMark0
> $24.28 Grace   0  00
> 0
> $(373.20)  Julie   Jocelyn Ryan0
> 0
>
> What should the statement be?  I cannot get the hang of logical
> operators in conditional formatting, any help would be appreciated.
>
> TIA
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*
*
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Conditional Formatting Excel 2007

[George Barrowcliff]

OK, please see attachment.

zp18

On Thu, Sep 8, 2011 at 2:22 PM, Venkat CV  wrote:

> Hi ,
>
> See Below Links...
> http://www.contextures.com/xlcondformat03.html\
>
> http://www.dummies.com/how-to/content/applying-conditional-formatting-in-excel-2007.html
>
> *Best Regards,*
> *Venkat *
> *Chennai*
> *My Linked in profile 
> *
> *
> *
>
> On Wed, Sep 7, 2011 at 1:30 PM, zp18  wrote:
>
>> A1=the name of an employee, defined name is "Suspect"
>> A2= an amount of money, defined as "MaxLoss"
>> B1:B8 is a column of money defined as "Shortages"
>> C1:G8 is a range of employee names defined as "Associates"
>>
>>
>> if the money contained in MaxLoss is less than the amount in column of
>> Shortages and the "Suspect"'s name is contained in the Associates
>> range then do something(bold, red, flashing etc)
>>
>>
>> The intent is to match an employees name to shortages using
>> conditional formatting
>>
>> James$57.20 Grace   Ronnie  MernalynIrene   0
>> -50  $4.91  Julie   Jocelyn Tiffany
>> RyanMark
>> $22.50 Grace   Ronnie  James   Irene   Mernalyn
>> $(0.78)Julie   Tiffany Ryan
>>  Mark0
>> $50.06 Grace   James   MernalynIrene   0
>> $2.65  Julie   Tiffany RyanMark0
>> $24.28 Grace   0  00
>> 0
>> $(373.20)  Julie   Jocelyn Ryan0
>> 0
>>
>> What should the statement be?  I cannot get the hang of logical
>> operators in conditional formatting, any help would be appreciated.
>>
>> TIA
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> *
> *
> *
> *
>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
George W

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


ConditionalFormatting.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Conditional Formatting using VBA

[NOORAIN ANSARI]

Dear George,

Please see attached sheet, I hope it will help to u.


-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 

On Wed, Dec 7, 2011 at 11:06 AM, George Barrowcliff wrote:

>
> Excel 2007-
>
> I have a spreadsheet that is updated frequently with new rows of data.
>
> I have a conditional format that is set for all rows and each time I add a
> new row I have to manually adjust the last row to encompass the newly added
> one.
>
> In the attached spreadsheet, new SKU data is added at the bottom of the
> existing data.  Column B is conditionally formatted based on the average of
> all elements in Column B starting at $B$3 and going through the last newly
> added $B$[new row].  The format is over the same range.  i.e. $B$3 to
> $B$[new row].
>
> I would like to do this through VBA triggered with a command button.
>
>
> Find the last cell and substitute it into the conditional format equation
> and range using VBA is the question.
>
>
> TIA
>
>
>  --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Copy of LastCell(Solved).xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ Conditional Formatting using VBA

[NOORAIN ANSARI]

Dear George,

Consider this one.

On Wed, Dec 7, 2011 at 11:06 AM, George Barrowcliff wrote:

>
> Excel 2007-
>
> I have a spreadsheet that is updated frequently with new rows of data.
>
> I have a conditional format that is set for all rows and each time I add a
> new row I have to manually adjust the last row to encompass the newly added
> one.
>
> In the attached spreadsheet, new SKU data is added at the bottom of the
> existing data.  Column B is conditionally formatted based on the average of
> all elements in Column B starting at $B$3 and going through the last newly
> added $B$[new row].  The format is over the same range.  i.e. $B$3 to
> $B$[new row].
>
> I would like to do this through VBA triggered with a command button.
>
>
> Find the last cell and substitute it into the conditional format equation
> and range using VBA is the question.
>
>
> TIA
>
>
>  --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Copy of LastCell(Solved).xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ Conditional Formatting using VBA

[Rohan]

Derived this from Noorain wondeful Solution. Some changes in the way
if have used vba.

Sub CF()

Dim CelRng As Range
LastRow = Range("B3").End(xlDown).Row
Set CelRng = Range("B3:B" & LastRow)

For i = 3 To LastRow
If Cells(i, "B").Value <
Application.WorksheetFunction.Average(CelRng) Then
Cells(i, "B").Interior.Color = vbCyan
End If
Next i

End Sub

Thanks,
Rohan

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Conditional formatting help - file attached

[Vaibhav Joshi]

check this...

Cheers!!

+
*I did not do this for you. God is here working through me for you.*

On Wed, Oct 1, 2014 at 4:25 PM, Pravin Gunjal  wrote:

> Hello Friends,
>
> I have attached an excel file, in which Column D, M and Y are very
> important in this file.
>
> *I need the following :*
> If a Division (Col D) has crossed 30 days (Col Y) and still not received
> an acknowledgement copy (Col M) then the entire row (from Column A to Y)
> must be highlighted with any of the background colors.
>
> Kindly do the needful.  Thank you,
>
> Regards
> Pravin Gunjal.
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


POD Working_conditional formatting.xlsb
Description: application/vnd.ms-excel.sheet.binary.macroenabled.12

Re: $$Excel-Macros$$ Conditional formatting for color cell

[Vaibhav Joshi]

Hi

I guess this is what you are looking for.

Cheers!!


On Fri, May 2, 2014 at 6:44 PM, amar takale  wrote:

>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE  : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Conditional formatting for color cell.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Conditional Formatting and Pick Lists

[Mahesh parab]

Hi Kristin

it seems you want to link 3 columns, if you select Particular Prod Name then
base on that, column 2nd & 3rd reflect
values, i herewith attach sheet, where 3 columns are link with drop down,
hope its as per your requirement,

for better understanding of your query send a sample sheet to this group.

On Tue, Jun 15, 2010 at 12:02 AM, Kristin  wrote:

> I am trying to create 3 columns for an ongoing monthly master
> spreadsheet.  The data includes: Product Name (highest level of info),
> Product Item # (essentially, a part #), and Product Description.
> Currently the list is 193 records long.
>
> I'd like for the first column (Product Name) to be a pick list
> consisting of 7 product names (I've got this done).  The second column
> to be a pick list based on which product name was picked in the first
> column and only show that subset of the master list pertaining to that
> product line.  And, the third column to auto-fill the product
> description for column two's product id.
>
> Is this possible?  I've been researching pick lists and conditional
> formatting, but can't seem to find a situation/example to where both
> are utilized within the same cell/column.
>
> I guess I need to know if this is possible and if not, I'll just go
> with pick lists for each column and hope for the best in accurate
> data.  If this is the only option, is there a limit to how long the
> pick list is?
>
> Lastly, I am not a developer and am not familiar with VBA or other
> scripting languages, etc.
>
> Thank you in advance for your help!
>
> Kristin
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


Sample dropdown.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Conditional Formatting and Pick Lists

[Kristin]

Hi Dave,

Greetings from the US!  This looks to be exactly what I need!  Now,
just to figure out how to implement it in my existing spreadsheet,
which is a shared doc for numerous people to access...is it possible
to start with your setup and change/add my real list data?  I'll begin
working with it to see.

Kristin

On Jun 17, 4:03 pm, Dave Bonallack  wrote:
> Hi Kristan,Have a look at the attached. It's a stripped down and modified 
> version of a sheet I designed a while ago. Perhaps it will suit your 
> purpose.Note that there are more named ranges than are needed for this 
> modified sheet, but I couldn't be bothered sorting out which ones were still 
> needed, so I've left most of them in. There's a master list, which I hope 
> resembles your own master list, and a Main sheet with a product drop-down in 
> Col A, dependent drop-down in Col B, and a formula to fill in the adjacent 
> cell in Col C.Regards from Brasil - Dave
>
> > Date: Mon, 14 Jun 2010 11:32:27 -0700
> > Subject: $$Excel-Macros$$ Conditional Formatting and Pick Lists
> > From: kristinmene...@gmail.com
> > To: excel-macros@googlegroups.com
>
> > I am trying to create 3 columns for an ongoing monthly master
> > spreadsheet.  The data includes: Product Name (highest level of info),
> > Product Item # (essentially, a part #), and Product Description.
> > Currently the list is 193 records long.
>
> > I'd like for the first column (Product Name) to be a pick list
> > consisting of 7 product names (I've got this done).  The second column
> > to be a pick list based on which product name was picked in the first
> > column and only show that subset of the master list pertaining to that
> > product line.  And, the third column to auto-fill the product
> > description for column two's product id.
>
> > Is this possible?  I've been researching pick lists and conditional
> > formatting, but can't seem to find a situation/example to where both
> > are utilized within the same cell/column.
>
> > I guess I need to know if this is possible and if not, I'll just go
> > with pick lists for each column and hope for the best in accurate
> > data.  If this is the only option, is there a limit to how long the
> > pick list is?
>
> > Lastly, I am not a developer and am not familiar with VBA or other
> > scripting languages, etc.
>
> > Thank you in advance for your help!
>
> > Kristin
>
> > --
> > --
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links 
> > :http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > HELP US GROW !!
>
> > We reach over 7000 subscribers worldwide and receive many nice notes about 
> > the learning and support from the group.Let friends and co-workers know 
> > they can subscribe to group 
> > athttp://groups.google.com/group/excel-macros/subscribe
>
> _
> View photos of singles in your area! Looking for a hot 
> date?http://clk.atdmt.com/NMN/go/150855801/direct/01/
>
>  Kristan.xls
> 154KViewDownload

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Conditional Formatting and Pick Lists

[Kristin]

Hi Dave,

I was able to use your solution and already have it implemented!
Everybody is really happy:-)  Thank you so much for the help!

I also wanted to thank Alvin and the others who have also provided
suggestions and solutions.  What a great group!

Thanks, again,

Kristin

On Jun 17, 4:03 pm, Dave Bonallack  wrote:
> Hi Kristan,Have a look at the attached. It's a stripped down and modified 
> version of a sheet I designed a while ago. Perhaps it will suit your 
> purpose.Note that there are more named ranges than are needed for this 
> modified sheet, but I couldn't be bothered sorting out which ones were still 
> needed, so I've left most of them in. There's a master list, which I hope 
> resembles your own master list, and a Main sheet with a product drop-down in 
> Col A, dependent drop-down in Col B, and a formula to fill in the adjacent 
> cell in Col C.Regards from Brasil - Dave
>
> > Date: Mon, 14 Jun 2010 11:32:27 -0700
> > Subject: $$Excel-Macros$$ Conditional Formatting and Pick Lists
> > From: kristinmene...@gmail.com
> > To: excel-macros@googlegroups.com
>
> > I am trying to create 3 columns for an ongoing monthly master
> > spreadsheet.  The data includes: Product Name (highest level of info),
> > Product Item # (essentially, a part #), and Product Description.
> > Currently the list is 193 records long.
>
> > I'd like for the first column (Product Name) to be a pick list
> > consisting of 7 product names (I've got this done).  The second column
> > to be a pick list based on which product name was picked in the first
> > column and only show that subset of the master list pertaining to that
> > product line.  And, the third column to auto-fill the product
> > description for column two's product id.
>
> > Is this possible?  I've been researching pick lists and conditional
> > formatting, but can't seem to find a situation/example to where both
> > are utilized within the same cell/column.
>
> > I guess I need to know if this is possible and if not, I'll just go
> > with pick lists for each column and hope for the best in accurate
> > data.  If this is the only option, is there a limit to how long the
> > pick list is?
>
> > Lastly, I am not a developer and am not familiar with VBA or other
> > scripting languages, etc.
>
> > Thank you in advance for your help!
>
> > Kristin
>
> > --
> > --
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links 
> > :http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > HELP US GROW !!
>
> > We reach over 7000 subscribers worldwide and receive many nice notes about 
> > the learning and support from the group.Let friends and co-workers know 
> > they can subscribe to group 
> > athttp://groups.google.com/group/excel-macros/subscribe
>
> _
> View photos of singles in your area! Looking for a hot 
> date?http://clk.atdmt.com/NMN/go/150855801/direct/01/
>
>  Kristan.xls
> 154KViewDownload

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

RE: $$Excel-Macros$$ Conditional Formatting and Pick Lists

[Dave Bonallack]

You are welcome.Dave

> Date: Fri, 18 Jun 2010 11:55:39 -0700
> Subject: Re: $$Excel-Macros$$ Conditional Formatting and Pick Lists
> From: kristinmene...@gmail.com
> To: excel-macros@googlegroups.com
> 
> Hi Dave,
> 
> I was able to use your solution and already have it implemented!
> Everybody is really happy:-)  Thank you so much for the help!
> 
> I also wanted to thank Alvin and the others who have also provided
> suggestions and solutions.  What a great group!
> 
> Thanks, again,
> 
> Kristin
> 
> On Jun 17, 4:03 pm, Dave Bonallack  wrote:
> > Hi Kristan,Have a look at the attached. It's a stripped down and modified 
> > version of a sheet I designed a while ago. Perhaps it will suit your 
> > purpose.Note that there are more named ranges than are needed for this 
> > modified sheet, but I couldn't be bothered sorting out which ones were 
> > still needed, so I've left most of them in. There's a master list, which I 
> > hope resembles your own master list, and a Main sheet with a product 
> > drop-down in Col A, dependent drop-down in Col B, and a formula to fill in 
> > the adjacent cell in Col C.Regards from Brasil - Dave
> >
> > > Date: Mon, 14 Jun 2010 11:32:27 -0700
> > > Subject: $$Excel-Macros$$ Conditional Formatting and Pick Lists
> > > From: kristinmene...@gmail.com
> > > To: excel-macros@googlegroups.com
> >
> > > I am trying to create 3 columns for an ongoing monthly master
> > > spreadsheet.  The data includes: Product Name (highest level of info),
> > > Product Item # (essentially, a part #), and Product Description.
> > > Currently the list is 193 records long.
> >
> > > I'd like for the first column (Product Name) to be a pick list
> > > consisting of 7 product names (I've got this done).  The second column
> > > to be a pick list based on which product name was picked in the first
> > > column and only show that subset of the master list pertaining to that
> > > product line.  And, the third column to auto-fill the product
> > > description for column two's product id.
> >
> > > Is this possible?  I've been researching pick lists and conditional
> > > formatting, but can't seem to find a situation/example to where both
> > > are utilized within the same cell/column.
> >
> > > I guess I need to know if this is possible and if not, I'll just go
> > > with pick lists for each column and hope for the best in accurate
> > > data.  If this is the only option, is there a limit to how long the
> > > pick list is?
> >
> > > Lastly, I am not a developer and am not familiar with VBA or other
> > > scripting languages, etc.
> >
> > > Thank you in advance for your help!
> >
> > > Kristin
> >
> > > --
> > > --
> > > Some important links for excel users:
> > > 1. Follow us on TWITTER for tips tricks and links 
> > > :http://twitter.com/exceldailytip
> > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
> >
> > > To post to this group, send email to excel-macros@googlegroups.com
> >
> > > <><><><><><><><><><><><><><><><><><><><><><>
> > > HELP US GROW !!
> >
> > > We reach over 7000 subscribers worldwide and receive many nice notes 
> > > about the learning and support from the group.Let friends and co-workers 
> > > know they can subscribe to group 
> > > athttp://groups.google.com/group/excel-macros/subscribe
> >
> > _
> > View photos of singles in your area! Looking for a hot 
> > date?http://clk.atdmt.com/NMN/go/150855801/direct/01/
> >
> >  Kristan.xls
> > 154KViewDownload
> 
> -- 
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links : 
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at ht

RE: $$Excel-Macros$$ Conditional Formatting and Pick Lists

[Dave Bonallack]

Hi Kristan,I got most of the ideas for the dependent drop-downs from this 
site:http://www.contextures.com/xlDataVal13.htmlThis is an excellent site, with 
lots of ideas, all clearly explained. It's worth working through the examples 
they show, in a clean sheet before trying to implement the method/s into 
existing workbook/s.Regards from Brasil (but only here visiting family - I'm 
usually in Perth, Australia)Dave.

> Date: Fri, 18 Jun 2010 08:52:44 -0700
> Subject: Re: $$Excel-Macros$$ Conditional Formatting and Pick Lists
> From: kristinmene...@gmail.com
> To: excel-macros@googlegroups.com
> 
> Hi Dave,
> 
> Greetings from the US!  This looks to be exactly what I need!  Now,
> just to figure out how to implement it in my existing spreadsheet,
> which is a shared doc for numerous people to access...is it possible
> to start with your setup and change/add my real list data?  I'll begin
> working with it to see.
> 
> Kristin
> 
> On Jun 17, 4:03 pm, Dave Bonallack  wrote:
> > Hi Kristan,Have a look at the attached. It's a stripped down and modified 
> > version of a sheet I designed a while ago. Perhaps it will suit your 
> > purpose.Note that there are more named ranges than are needed for this 
> > modified sheet, but I couldn't be bothered sorting out which ones were 
> > still needed, so I've left most of them in. There's a master list, which I 
> > hope resembles your own master list, and a Main sheet with a product 
> > drop-down in Col A, dependent drop-down in Col B, and a formula to fill in 
> > the adjacent cell in Col C.Regards from Brasil - Dave
> >
> > > Date: Mon, 14 Jun 2010 11:32:27 -0700
> > > Subject: $$Excel-Macros$$ Conditional Formatting and Pick Lists
> > > From: kristinmene...@gmail.com
> > > To: excel-macros@googlegroups.com
> >
> > > I am trying to create 3 columns for an ongoing monthly master
> > > spreadsheet.  The data includes: Product Name (highest level of info),
> > > Product Item # (essentially, a part #), and Product Description.
> > > Currently the list is 193 records long.
> >
> > > I'd like for the first column (Product Name) to be a pick list
> > > consisting of 7 product names (I've got this done).  The second column
> > > to be a pick list based on which product name was picked in the first
> > > column and only show that subset of the master list pertaining to that
> > > product line.  And, the third column to auto-fill the product
> > > description for column two's product id.
> >
> > > Is this possible?  I've been researching pick lists and conditional
> > > formatting, but can't seem to find a situation/example to where both
> > > are utilized within the same cell/column.
> >
> > > I guess I need to know if this is possible and if not, I'll just go
> > > with pick lists for each column and hope for the best in accurate
> > > data.  If this is the only option, is there a limit to how long the
> > > pick list is?
> >
> > > Lastly, I am not a developer and am not familiar with VBA or other
> > > scripting languages, etc.
> >
> > > Thank you in advance for your help!
> >
> > > Kristin
> >
> > > --
> > > --
> > > Some important links for excel users:
> > > 1. Follow us on TWITTER for tips tricks and links 
> > > :http://twitter.com/exceldailytip
> > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
> >
> > > To post to this group, send email to excel-macros@googlegroups.com
> >
> > > <><><><><><><><><><><><><><><><><><><><><><>
> > > HELP US GROW !!
> >
> > > We reach over 7000 subscribers worldwide and receive many nice notes 
> > > about the learning and support from the group.Let friends and co-workers 
> > > know they can subscribe to group 
> > > athttp://groups.google.com/group/excel-macros/subscribe
> >
> > _
> > View photos of singles in your area! Looking for a hot 
> > date?http://clk.atdmt.com/NMN/go/150855801/direct/01/
> >
> >  Kristan.xls

Re: $$Excel-Macros$$ Conditional Formatting on a formula

[Nadine S]

Thanks but this still isn't working if the formula result for a cell is blank.





From: Rajender Soni 
To: excel-macros@googlegroups.com
Sent: Thu, August 12, 2010 8:51:03 PM
Subject: $$Excel-Macros$$ Conditional Formatting on a formula


Hi

Please find attached the solution sheet.


 
Regards,
Rajender Soni | +91 750 322 55 50
-- 
--

Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
 
We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe



  

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

RE: $$Excel-Macros$$ conditional formatting based on calculation

[Daniel]

Select February – July data

First rule :

=(C2-B2)/B2>0.05  è Red

Second rule :

=AND((C2-B2)/B2>0,(C2-B2)/B2<=0.05)  è yellow

Third rule :

=C2mailto:excel-macros@googlegroups.com] De
la part de Jagadeesh B S
Envoyé : jeudi 4 août 2011 13:00
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ conditional formatting based on calculation

 

Pdt Jan Feb March April May June July
A 0.52 0.60 0.60 0.71 0.71 0.66 0.00
B 0.72 0.72 0.71 0.86 0.96 0.81 0.77
C 3.84 4.35 4.39 3.88 4.23 4.06 3.69
D 1.16 1.49 1.49 1.49 1.67 1.92 0.00
E 1.13 1.32 1.32 1.57 1.57 1.44 0.00
F 1.14 1.29 1.29 1.29 3.12 3.18 0.00

I can to apply conditional formatting for the columns
My condition is
If the price changed b/w jan and feb greater then 5% then red if it’s less
than 5% is yellow and –ve figures as Green.

Please help me what formula I need to put to get the same.

Thanks In advance.

 

-- 

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at  
http://exceldailytip.blogspot.com

To post to this group, send email to  
excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
  http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ conditional formatting based on calculation

[XLS S]

Please see attachment.

On Thu, Aug 4, 2011 at 4:29 PM, Jagadeesh B S  wrote:
> Pdt Jan Feb March April May June July
> A 0.52 0.60 0.60 0.71 0.71 0.66 0.00
> B 0.72 0.72 0.71 0.86 0.96 0.81 0.77
> C 3.84 4.35 4.39 3.88 4.23 4.06 3.69
> D 1.16 1.49 1.49 1.49 1.67 1.92 0.00
> E 1.13 1.32 1.32 1.57 1.57 1.44 0.00
> F 1.14 1.29 1.29 1.29 3.12 3.18 0.00
>
> I can to apply conditional formatting for the columns
> My condition is
> If the price changed b/w jan and feb greater then 5% then red if it’s less
> than 5% is yellow and –ve figures as Green.
>
> Please help me what formula I need to put to get the same.
>
> Thanks In advance.
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


See.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Conditional Formatting and Logical Operators

[Venkat CV]

Hi,

See below links if helps..

http://www.cpearson.com/excel/cformatting.htm
http://www.excelforum.com/excel-general/497309-can-logical-operators-be-used-within-conditional-formatting.html

*Best Regards,*
*Venkat *
*Chennai*
*
*

On Wed, Aug 31, 2011 at 11:36 AM, zp18  wrote:

> Excel 7
> I have 60 rows, one for each of two shifts, each day of the month
> Each row has 7 columns with an employee name in each column
> I have one column (M) with the  number of hours worked.
>
>
> I have a constant field named "Associate"  which contains the name of
> one of the employees
>
> Currently I have conditional formatting the will highlight the
> employee whose name is contained in the "Associate" cell
>
> and it the rule looks like this:
>  Cell value = Associate   Format[black, yellow background] Applies to
> =$N$30:$T$89
>
>
> I want to add in the condition of the hours worked column (M) less
> than 4.5 in order for the format to be true.
>
> How can I add this condition?
>
> I tried:   =AND($N30:$T30=Associate,$M30
> Thanks, zp18
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ conditional formatting- more than 3

[ashish koul]

http://chandoo.org/wp/2008/10/14/more-than-3-conditional-formats-in-excel/

http://en.kioskea.net/forum/affich-21716-conditional-formatting-more-than-3-in-excel



On Tue, Oct 18, 2011 at 9:04 AM, Kuts  wrote:

> Hi
>
> I am xavier, new to this group. Please help me in conditional
> formatting i use excel 2003 and it does not allow more than 3
> conditions. Someone can help please
>
> Many Thanks
> Xavier
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*http://www.excelvbamacros.com/*


P Before printing, think about the environment.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ conditional formatting- more than 3

[NOORAIN ANSARI]

Dear Kuts,

Please see attached sheet i hope it help to u


Private Sub Worksheet_Change(ByVal Target As Range)
Dim icolor As Integer
If Not Intersect(Target, Range("A1:A10")) Is Nothing Then
Select Case Target
Case 1 To 5
icolor = 6
Case 6 To 10
icolor = 12
Case 11 To 15
icolor = 7
Case 16 To 20
icolor = 53
Case 21 To 25
icolor = 15
Case 26 To 30
icolor = 42
Case Else
'Whatever
End Select
Target.Interior.ColorIndex = icolor
End If
End Sub


-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 

On Tue, Oct 18, 2011 at 9:04 AM, Kuts  wrote:

> Hi
>
> I am xavier, new to this group. Please help me in conditional
> formatting i use excel 2003 and it does not allow more than 3
> conditions. Someone can help please
>
> Many Thanks
> Xavier
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Conditional_Formating_More than 3 in 2003.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Conditional Formatting using named ranges

[dguillett1]

Post your macro code and/or attach your file.



Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message- 
From: zp18

Sent: Tuesday, November 22, 2011 5:52 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Conditional Formatting using named ranges

Excel 2007-

I have a large spreadsheet that I add 2 rows to daily.  I also have
about a dozen conditional formatting formulas that flag certain
conditions for quick identification.  The worksheet that gets the
daily data is named "DataSheet"

I've written a quick VBA Macro that sets a named range "LastRow" on
the "Constants" worksheet to be the last row of the "DataSheet"
worksheet.  When I run that, it sets LastRow to 680  (today).

How can I adjust by conditional formatting rules to format down to the
value in LastRow?

In this case, water meter readings are recorded on a daily basis.  A
maximum of 2 cubic meters usage is OK, so a named range called
WaterAlarm on the Constants page is set to 2.0

e.g.  Here is the formula:   =AU453-AT453>WaterAlarm  and the range it
applies to is:  =$AU$453:$AU$674

Ideally this would adjust to the last row for all the conditional
formatting when I run the macro that sets the "LastRow"

I guess I could just add all the conditional formatting to the Macro
and be done with it but it would be nice to know how to do it in the
conditional formatting context.

Thanks

--
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please 
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will 
not get quick attention or may not be answered.


2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security 
measure.


4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited.


NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.


--
To post to this group, send email to excel-macros@googlegroups.com 


--
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 


NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Conditional Formatting using named ranges

[Rohan]

Not figured out what your macro ishowever what I can suggest you
can use the Offset function to have the range of the
Conditional formating extended automatically.

Use, =Offset(A1, Counta(A:A), 0), assuming you want to apply
conditional formatting in the column A.

Put the above stated formula in the Conditonal Formatting dialog box,
where it says "Applies to"


Lemme know, if you have questions.


Rohan.

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Conditional Formatting using named ranges

[rajan verma]

hi
can you not refer your named range in conditional formatting.

On Thu, Dec 8, 2011 at 4:22 AM, Rohan  wrote:

> Not figured out what your macro ishowever what I can suggest you
> can use the Offset function to have the range of the
> Conditional formating extended automatically.
>
> Use, =Offset(A1, Counta(A:A), 0), assuming you want to apply
> conditional formatting in the column A.
>
> Put the above stated formula in the Conditonal Formatting dialog box,
> where it says "Applies to"
>
>
> Lemme know, if you have questions.
>
>
> Rohan.
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Regards
Rajan verma
+91 9158998701

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Conditional formatting on a workbook

[PrIyAnKa]

Dear Chan

kindly also let the group know where and which conditional formatting u
want in your sheet

On Fri, Feb 17, 2012 at 2:01 PM, Darwin Chan wrote:

> Dear group,
>
> i have a workbook which is set as shared, however, i found it could not
> apply conditional formatting. Could anybody offer help?
>
> --
> Darwin Chan
> darwin.chankaw...@gmail.com
>  kw42c...@yahoo.com.hk
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Conditional formatting on a workbook

[NOORAIN ANSARI]

Dear Darwin,

You can use vba coding for conditional formatting during share mod


On Fri, Feb 17, 2012 at 2:01 PM, Darwin Chan wrote:

> Dear group,
>
> i have a workbook which is set as shared, however, i found it could not
> apply conditional formatting. Could anybody offer help?
>
> --
> Darwin Chan
> darwin.chankaw...@gmail.com
>  kw42c...@yahoo.com.hk
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Thanks & regards,
Noorain Ansari
 ** *http://noorainansari.com/*
*http://excelmacroworld.blogspot.com/*

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Conditional formatting on a workbook

[Sam Mathai Chacko]

You *cannot *view the VBE when the file is in share mod, and hence you
cannot build the code in conditional formatting. Even manually also, you
will not be able to setup a conditional format. If the conditional format
was already setup, then that will work even if the file is shared.

Sam Mathai Chacko

On Fri, Feb 17, 2012 at 3:27 PM, NOORAIN ANSARI wrote:

> Dear Darwin,
>
> You can use vba coding for conditional formatting during share mod
>
>
> On Fri, Feb 17, 2012 at 2:01 PM, Darwin Chan 
> wrote:
>
>> Dear group,
>>
>> i have a workbook which is set as shared, however, i found it could not
>> apply conditional formatting. Could anybody offer help?
>>
>> --
>> Darwin Chan
>> darwin.chankaw...@gmail.com
>>  kw42c...@yahoo.com.hk
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
>  ** *http://noorainansari.com/*
> *http://excelmacroworld.blogspot.com/*
>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Sam Mathai Chacko

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Conditional formatting ( After 2 criteria match)

[priti verma]

Hi Amar,
you can use this formula in conditional formating>new rule.
=C31=INDEX($C$31:$J$38,MATCH($F$5,$C$31:$C$38,0),MATCH($C$4,$C$31:$J$31,0))
please let me know if this will not fulfill your requirement .
Regards
Priti verma



On Sat, May 11, 2013 at 1:17 PM, amar takale  wrote:

> Dear Experts
> Required Conditional formatting ( After 2 criteria match).Pls see sheet
> with detailed information.
> Regards
> Amar
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Conditional formatting ( After 2 criteria match)

[amar takale]

Dear Priti
Thats Great!!! Thanks very much priti madam.
Regards
Amar


On Sat, May 11, 2013 at 3:58 PM, priti verma wrote:

> Hi Amar,
> you can use this formula in conditional formating>new rule.
> =C31=INDEX($C$31:$J$38,MATCH($F$5,$C$31:$C$38,0),MATCH($C$4,$C$31:$J$31,0))
> please let me know if this will not fulfill your requirement .
> Regards
> Priti verma
>
>
>
> On Sat, May 11, 2013 at 1:17 PM, amar takale  wrote:
>
>> Dear Experts
>> Required Conditional formatting ( After 2 criteria match).Pls see sheet
>> with detailed information.
>> Regards
>> Amar
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

RE: $$Excel-Macros$$ Conditional Formatting or 16 Nested IFs.

[Dave Bonallack]

Hi Alex,
You need to use absolute refs.
Instead of:
=LARGE(D12:S12,1), =LARGE(D12:S12,2), and =LARGE(D12:S12,3)
try:
=LARGE($D$12:$S$12,1), =LARGE($D$12:$S$12,2), and =LARGE($D$12:$S$12,3)

Regards - Dave.

> Date: Fri, 8 Jan 2010 07:52:45 -0800
> Subject: $$Excel-Macros$$ Conditional Formatting or 16 Nested IFs.
> From: alex.jo...@gmail.com
> To: excel-macros@googlegroups.com
> 
> Hello, before getting into what I am looking for and my frustration
> with Excel, I will let you knwo I have already tried various tricks
> with nesting more than 7 IF statements in Excel 2000.
> 
> Anyway, I've set up a spreadsheet (obviously) that is being used to
> operate a sports pool.
> 
> I've set it up to have cell validation for picks, and integrated inthe
> points totals and scoring etc.
> 
> What I need (read: want) is for the final round sheet (each round has
> a spearate sheet) to identify the leader/winner, 1st and 2nd runners-
> up.
> 
> I originally used a nested IF to simply display the names of the 1st,
> 2nd and 3rd place participants but as the pool grew, I need more nests
> and quickly got to 16, and using VBA is not an option (work
> computer).  I tried the & trick, and setting 3 sets of nested ifs with
> a master IF cell integrating the results of those other three.
> Anyway, I've opted to use conditional formatting to simply highlight
> the highest scores.
> 
> The set-up:
> 
> ROW 12, specifically D12:S12 show the total points for each
> participant.
> 
> I want the 1st place (highest score) to highlight red, 2nd blue, 3rd
> yellow.
> 
> I selected the cells D12:S12 and set conditional formatting using:
> 
> If cell is equal to "=LARGE(D12:S12,1)", "=LARGE(D12:S12,2)", and
> "=LARGE(D12:S12,3)" as my conditions.
> 
> the issue is that the cells don't format correctly.
> 
> For example:
> 
> Cell D12 will have the right parameters (upon checking) of (D12:S12,1)
> etc
> Cell E12 will not have these same parameters, instead has (E12:T12,1)
> etc
> .
> .
> .
> Cell S12 will have (S12:AI12,1) as its parameters.
> 
> What am I doing wrong? I'd rather not go through each cell and
> manually input conditions for each one.
> 
> if more info is needed let me know.
  
_
Video chat with Windows Live Messenger Learn how
http://windowslive.ninemsn.com.au/messenger/article/870686/video-chat-with-messenger-- 
--
Some important links for excel users:
1. Follow us in TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Conditional Formatting Highlight of Changed Cells

[Sam Mathai Chacko]

Goto VBE, insert a new module in your workbook vba project, and add this
function

Function HASFORMULA(rngCell As Range) As Boolean

HASFORMULA = rngCell.HASFORMULA

End Function

In your conditional format rule, use =HASFORMULA(A1)

Regards,

Sam

On Thu, Oct 6, 2011 at 2:29 AM, Craig Brandt  wrote:

> Conditional Formatting Highlight of Changed Cells
> I have a large spreadsheet where users occasionally will overwrite the
> builtin formula with a value. I would like Conditional Formatting to
> highlight these cells that were changed from a formula to a numeric
> value. My first shot in Cell “A1” was a conditional formula of
> “ISNUMERIC(A1)” just to see if it could detect a number as opposed to
> a formula. Did nothing and I cannot find an alternate solution. I saw
> suggestions of using a user defined Function but very limited exposure
> to that and didn’t have any success in making it work.
>
> Thanks for any help,
> Craig
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Sam Mathai Chacko

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Conditional Formatting Highlight of Changed Cells

[Mahesh parab]

Hi Craig

you can use Track changes option from excel

http://office.microsoft.com/en-us/excel-help/about-tracking-changes-HP005230064.aspx

HTH
Mahesh

On Thu, Oct 6, 2011 at 1:24 PM, Sam Mathai Chacko wrote:

> Goto VBE, insert a new module in your workbook vba project, and add this
> function
>
> Function HASFORMULA(rngCell As Range) As Boolean
>
> HASFORMULA = rngCell.HASFORMULA
>
> End Function
>
> In your conditional format rule, use =HASFORMULA(A1)
>
> Regards,
>
> Sam
>
>
> On Thu, Oct 6, 2011 at 2:29 AM, Craig Brandt wrote:
>
>> Conditional Formatting Highlight of Changed Cells
>> I have a large spreadsheet where users occasionally will overwrite the
>> builtin formula with a value. I would like Conditional Formatting to
>> highlight these cells that were changed from a formula to a numeric
>> value. My first shot in Cell “A1” was a conditional formula of
>> “ISNUMERIC(A1)” just to see if it could detect a number as opposed to
>> a formula. Did nothing and I cannot find an alternate solution. I saw
>> suggestions of using a user defined Function but very limited exposure
>> to that and didn’t have any success in making it work.
>>
>> Thanks for any help,
>> Craig
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> Sam Mathai Chacko
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Conditional Formatting Highlight of Changed Cells

[NOORAIN ANSARI]

Dear Craig,

Please Try

Review-Track Change..

On Thu, Oct 6, 2011 at 2:29 AM, Craig Brandt  wrote:

> Conditional Formatting Highlight of Changed Cells
> I have a large spreadsheet where users occasionally will overwrite the
> builtin formula with a value. I would like Conditional Formatting to
> highlight these cells that were changed from a formula to a numeric
> value. My first shot in Cell “A1” was a conditional formula of
> “ISNUMERIC(A1)” just to see if it could detect a number as opposed to
> a formula. Did nothing and I cannot find an alternate solution. I saw
> suggestions of using a user defined Function but very limited exposure
> to that and didn’t have any success in making it work.
>
> Thanks for any help,
> Craig
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Conditional Formatting Highlight of Changed Cells

[Dilip Pandey]

Hi Craig,

Please find the solution attached as a sample.  It has the same idea
as suggested by Sam.  Thanks.

Feel free to get back in case of any queries.

Regards,
DILIPandey

On 10/6/11, Craig Brandt  wrote:
> Conditional Formatting Highlight of Changed Cells
> I have a large spreadsheet where users occasionally will overwrite the
> builtin formula with a value. I would like Conditional Formatting to
> highlight these cells that were changed from a formula to a numeric
> value. My first shot in Cell “A1” was a conditional formula of
> “ISNUMERIC(A1)” just to see if it could detect a number as opposed to
> a formula. Did nothing and I cannot find an alternate solution. I saw
> suggestions of using a user defined Function but very limited exposure
> to that and didn’t have any success in making it work.
>
> Thanks for any help,
> Craig
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>


-- 
Thanks & Regards,

DILIP KUMAR PANDEY, mvp
   MBA,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


CF-HasFormula chk.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ Conditional Formatting Highlight of Changed Cells

[Craig Brandt]

Sam,

Thanks for your solution. I got it to work and with the modification
suggested by DILIPandey, it does what I wanted. I just have to be
careful that my user enters "5%" and not "=5%".
The "track changes", while interesting and will be used in the future,
didn't fit because the formulas can be changed to other formulas and
this is OK. I wanted to highlight only those cells take had a hard
coded numbers in them.

Thank you all for your asistance,
Craig

On Oct 6, 2:54 am, Sam Mathai Chacko  wrote:
> Goto VBE, insert a new module in your workbook vba project, and add this
> function
>
> Function HASFORMULA(rngCell As Range) As Boolean
>
>     HASFORMULA = rngCell.HASFORMULA
>
> End Function
>
> In your conditional format rule, use =HASFORMULA(A1)
>
> Regards,
>
> Sam
>
>
>
>
>
> On Thu, Oct 6, 2011 at 2:29 AM, Craig Brandt  wrote:
> > Conditional Formatting Highlight of Changed Cells
> > I have a large spreadsheet where users occasionally will overwrite the
> > builtin formula with a value. I would like Conditional Formatting to
> > highlight these cells that were changed from a formula to a numeric
> > value. My first shot in Cell “A1” was a conditional formula of
> > “ISNUMERIC(A1)” just to see if it could detect a number as opposed to
> > a formula. Did nothing and I cannot find an alternate solution. I saw
> > suggestions of using a user defined Function but very limited exposure
> > to that and didn’t have any success in making it work.
>
> > Thanks for any help,
> > Craig
>
> > --
>
> > ---­---
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> >http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> >http://www.facebook.com/discussexcel
>
> --
> Sam Mathai Chacko- Hide quoted text -
>
> - Show quoted text -

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ conditional formatting for real time stock quotes

[Sam Mathai Chacko]

For that you'll have to first tell how your sheet gets refreshed? Is it
linked to a web query? Normally, you'd want to save the existing values in
a second sheet, and make the conditional comparison based on the current
value.

Regards,

Sam

On Thu, Nov 3, 2011 at 8:20 PM, ajjw123  wrote:

> i have a excel sheet in which real time stock quotes gets updated
> automatically every second.
> I would like to highlight the value as red if the new stock quote is
> greater than the previous one.
> And highlight the quote as blue if the new stock quote is lesser than
> the previous one.
> thanks.
>
> --
> FORUM RULES (925+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Sam Mathai Chacko

-- 
FORUM RULES (925+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ conditional formatting for real time stock quotes

[Sam Mathai Chacko]

Here's a simulated refresh to give you the idea of how it can be done. Now,
my trigger is the click of a button. But in your case, it could be the
query refresh.

Regards

Sam

On Thu, Nov 3, 2011 at 8:23 PM, Sam Mathai Chacko wrote:

> For that you'll have to first tell how your sheet gets refreshed? Is it
> linked to a web query? Normally, you'd want to save the existing values in
> a second sheet, and make the conditional comparison based on the current
> value.
>
> Regards,
>
> Sam
>
>
> On Thu, Nov 3, 2011 at 8:20 PM, ajjw123  wrote:
>
>> i have a excel sheet in which real time stock quotes gets updated
>> automatically every second.
>> I would like to highlight the value as red if the new stock quote is
>> greater than the previous one.
>> And highlight the quote as blue if the new stock quote is lesser than
>> the previous one.
>> thanks.
>>
>> --
>> FORUM RULES (925+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5)  Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE  : Don't ever post personal or confidential data in a workbook.
>> Forum owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> Sam Mathai Chacko
>



-- 
Sam Mathai Chacko

-- 
FORUM RULES (925+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Live Change Track.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ conditional formatting for real time stock quotes

[ajjw123]

thanks for the reply .The data is linked to a application which
automatically paste data in sheet1 of the workbook.And I have to link
the data from sheet1 to another worksheets or workbook as i cant
change anything in sheet1.


On Nov 3, 8:36 pm, Sam Mathai Chacko  wrote:
> Here's a simulated refresh to give you the idea of how it can be done. Now,
> my trigger is the click of a button. But in your case, it could be the
> query refresh.
>
> Regards
>
> Sam
>
> On Thu, Nov 3, 2011 at 8:23 PM, Sam Mathai Chacko wrote:
>
>
>
>
>
>
>
>
>
> > For that you'll have to first tell how your sheet gets refreshed? Is it
> > linked to a web query? Normally, you'd want to save the existing values in
> > a second sheet, and make the conditional comparison based on the current
> > value.
>
> > Regards,
>
> > Sam
>
> > On Thu, Nov 3, 2011 at 8:20 PM, ajjw123  wrote:
>
> >> i have a excel sheet in which real time stock quotes gets updated
> >> automatically every second.
> >> I would like to highlight the value as red if the new stock quote is
> >> greater than the previous one.
> >> And highlight the quote as blue if the new stock quote is lesser than
> >> the previous one.
> >> thanks.
>
> >> --
> >> FORUM RULES (925+ members already BANNED for violation)
>
> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> >> will not get quick attention or may not be answered.
>
> >> 2) Don't post a question in the thread of another member.
>
> >> 3) Don't post questions regarding breaking or bypassing any security
> >> measure.
>
> >> 4) Acknowledge the responses you receive, good or bad.
>
> >> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> >> signatures are prohibited.
>
> >> NOTE  : Don't ever post personal or confidential data in a workbook.
> >> Forum owners and members are not responsible for any loss.
>
> >> --
> >> To post to this group, send email to excel-macros@googlegroups.com
>
> > --
> > Sam Mathai Chacko
>
> --
> Sam Mathai Chacko
>
>  Live Change Track.xlsm
> 25KViewDownload

-- 
FORUM RULES (925+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ conditional formatting for real time stock quotes

[dguillett1]

Post your file.



Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message- 
From: ajjw123

Sent: Friday, November 04, 2011 1:05 AM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ conditional formatting for real time stock 
quotes


thanks for the reply .The data is linked to a application which
automatically paste data in sheet1 of the workbook.And I have to link
the data from sheet1 to another worksheets or workbook as i cant
change anything in sheet1.


On Nov 3, 8:36 pm, Sam Mathai Chacko  wrote:
Here's a simulated refresh to give you the idea of how it can be done. 
Now,

my trigger is the click of a button. But in your case, it could be the
query refresh.

Regards

Sam

On Thu, Nov 3, 2011 at 8:23 PM, Sam Mathai Chacko 
wrote:










> For that you'll have to first tell how your sheet gets refreshed? Is it
> linked to a web query? Normally, you'd want to save the existing values 
> in

> a second sheet, and make the conditional comparison based on the current
> value.

> Regards,

> Sam

> On Thu, Nov 3, 2011 at 8:20 PM, ajjw123  wrote:

>> i have a excel sheet in which real time stock quotes gets updated
>> automatically every second.
>> I would like to highlight the value as red if the new stock quote is
>> greater than the previous one.
>> And highlight the quote as blue if the new stock quote is lesser than
>> the previous one.
>> thanks.

>> --
>> FORUM RULES (925+ members already BANNED for violation)

>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.

>> 2) Don't post a question in the thread of another member.

>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.

>> 4) Acknowledge the responses you receive, good or bad.

>> 5)  Cross-promotion of, or links to, forums competitive to this forum 
>> in

>> signatures are prohibited.

>> NOTE  : Don't ever post personal or confidential data in a workbook.
>> Forum owners and members are not responsible for any loss.

>> 
--
>> To post to this group, send email to excel-macros@googlegroups.com

> --
> Sam Mathai Chacko

--
Sam Mathai Chacko

 Live Change Track.xlsm
25KViewDownload


--
FORUM RULES (925+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please 
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will 
not get quick attention or may not be answered.


2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security 
measure.


4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited.


NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.


--
To post to this group, send email to excel-macros@googlegroups.com 


--
FORUM RULES (925+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 


NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Conditional formatting of entire row using VBA

[dguillett1]

Right click sheet tab>view code>insert this

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Or Target.Column <> 1 Then Exit Sub
Select Case LCase(Target)
Case Is = "one": x = 1
Case Is = "one": x = 1
Case Is = "two": x = 6
Case Is = "three": x = 3
Case Is = "four": x = 4
Case Else
End Select
Rows(Target.Row).Interior.ColorIndex = x
End Sub



Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message- 
From: FJO

Sent: Tuesday, November 15, 2011 7:49 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Conditional formatting of entire row using VBA

Hi

Can anyone help me with the VBA code for conditional formatting in
Excel.

I have af worksheet of 1000 rows with 5 colums. I have data in colum
B;E and would like Excel to format the rows in a colour depending of
what I write in colum A.

I have 5 different text imput I can chose for each row, lets call
them
"one"
"two"
"Three"
"Four"
"Five"

...just to keep this example as simple as possible.

If I write "one" in A2, I would like Excel to color Row 2 in one
color, if I write "Two" then another color and so on.

I found out how to color the cell I changed, but I would like to have
the whole row colored.

I hope someone can send me an example.

--
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please 
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will 
not get quick attention or may not be answered.


2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security 
measure.


4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited.


NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.


--
To post to this group, send email to excel-macros@googlegroups.com 


--
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 


NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Conditional formatting of entire row using VBA

[Sam Mathai Chacko]

Here's how you do it. Select your entire row. Assuming your top left cell
in the entire selection is A1 (will be any one cell in the first column
depending on where you started your selection)

Go to conditional format, and in the options 'Use formula to determine
which cells to format', write =$A1="One"

and then apply the required format you need.

Check the attachment.

Regards,

Sam Mathai Chacko

On Tue, Nov 15, 2011 at 7:19 PM, FJO  wrote:

> Hi
>
> Can anyone help me with the VBA code for conditional formatting in
> Excel.
>
> I have af worksheet of 1000 rows with 5 colums. I have data in colum
> B;E and would like Excel to format the rows in a colour depending of
> what I write in colum A.
>
> I have 5 different text imput I can chose for each row, lets call
> them
> "one"
> "two"
> "Three"
> "Four"
> "Five"
>
> ...just to keep this example as simple as possible.
>
> If I write "one" in A2, I would like Excel to color Row 2 in one
> color, if I write "Two" then another color and so on.
>
> I found out how to color the cell I changed, but I would like to have
> the whole row colored.
>
> I hope someone can send me an example.
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Sam Mathai Chacko

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Conditional Format On Entire Row.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Conditional formatting of entire row using VBA

[dguillett1]

Sam,
> "one"
> "two"

Don Guillett
SalesAid Software
dguille...@gmail.com

From: Sam Mathai Chacko 
Sent: Tuesday, November 15, 2011 10:21 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Conditional formatting of entire row using VBA

Here's how you do it. Select your entire row. Assuming your top left cell in 
the entire selection is A1 (will be any one cell in the first column depending 
on where you started your selection)

Go to conditional format, and in the options 'Use formula to determine which 
cells to format', write =$A1="One"

and then apply the required format you need.

Check the attachment.

Regards,

Sam Mathai Chacko


On Tue, Nov 15, 2011 at 7:19 PM, FJO  wrote:

  Hi

  Can anyone help me with the VBA code for conditional formatting in
  Excel.

  I have af worksheet of 1000 rows with 5 colums. I have data in colum
  B;E and would like Excel to format the rows in a colour depending of
  what I write in colum A.

  I have 5 different text imput I can chose for each row, lets call
  them
  "one"
  "two"
  "Three"
  "Four"
  "Five"

  ...just to keep this example as simple as possible.

  If I write "one" in A2, I would like Excel to color Row 2 in one
  color, if I write "Two" then another color and so on.

  I found out how to color the cell I changed, but I would like to have
  the whole row colored.

  I hope someone can send me an example.

  --
  FORUM RULES (934+ members already BANNED for violation)

  1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

  2) Don't post a question in the thread of another member.

  3) Don't post questions regarding breaking or bypassing any security measure.

  4) Acknowledge the responses you receive, good or bad.

  5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited.

  NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

  
--
  To post to this group, send email to excel-macros@googlegroups.com




-- 
Sam Mathai Chacko
-- 
FORUM RULES (934+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Conditional formatting of entire row using VBA

[Sam Mathai Chacko]

Yes Don. I was just showing how it is done for one conditional. I had it
done for One to Five in the attachment I had posted.

Regards,

Sam

On Tue, Nov 15, 2011 at 10:07 PM, dguillett1  wrote:

>   Sam,
> > "one"
> > "two"
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* Sam Mathai Chacko 
> *Sent:* Tuesday, November 15, 2011 10:21 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Conditional formatting of entire row
> using VBA
>
> Here's how you do it. Select your entire row. Assuming your top left cell
> in the entire selection is A1 (will be any one cell in the first column
> depending on where you started your selection)
>
> Go to conditional format, and in the options 'Use formula to determine
> which cells to format', write =$A1="One"
>
> and then apply the required format you need.
>
> Check the attachment.
>
> Regards,
>
> Sam Mathai Chacko
>
> On Tue, Nov 15, 2011 at 7:19 PM, FJO  wrote:
>
>> Hi
>>
>> Can anyone help me with the VBA code for conditional formatting in
>> Excel.
>>
>> I have af worksheet of 1000 rows with 5 colums. I have data in colum
>> B;E and would like Excel to format the rows in a colour depending of
>> what I write in colum A.
>>
>> I have 5 different text imput I can chose for each row, lets call
>> them
>> "one"
>> "two"
>> "Three"
>> "Four"
>> "Five"
>>
>> ...just to keep this example as simple as possible.
>>
>> If I write "one" in A2, I would like Excel to color Row 2 in one
>> color, if I write "Two" then another color and so on.
>>
>> I found out how to color the cell I changed, but I would like to have
>> the whole row colored.
>>
>> I hope someone can send me an example.
>>
>> --
>> FORUM RULES (934+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5)  Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE  : Don't ever post personal or confidential data in a workbook.
>> Forum owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> Sam Mathai Chacko
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> -

Re: $$Excel-Macros$$ Conditional formatting of entire row using VBA

[dguillett1]

Sam, I’m sorry.I opened in xl2003duh

Don Guillett
SalesAid Software
dguille...@gmail.com

From: Sam Mathai Chacko 
Sent: Tuesday, November 15, 2011 10:51 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Conditional formatting of entire row using VBA

Yes Don. I was just showing how it is done for one conditional. I had it done 
for One to Five in the attachment I had posted.

Regards,

Sam


On Tue, Nov 15, 2011 at 10:07 PM, dguillett1  wrote:

  Sam,
  > "one"
  > "two"

  Don Guillett
  SalesAid Software
  dguille...@gmail.com

  From: Sam Mathai Chacko 
  Sent: Tuesday, November 15, 2011 10:21 AM
  To: excel-macros@googlegroups.com 
  Subject: Re: $$Excel-Macros$$ Conditional formatting of entire row using VBA

  Here's how you do it. Select your entire row. Assuming your top left cell in 
the entire selection is A1 (will be any one cell in the first column depending 
on where you started your selection)

  Go to conditional format, and in the options 'Use formula to determine which 
cells to format', write =$A1="One"

  and then apply the required format you need.

  Check the attachment.

  Regards,

  Sam Mathai Chacko


  On Tue, Nov 15, 2011 at 7:19 PM, FJO  wrote:

Hi

Can anyone help me with the VBA code for conditional formatting in
Excel.

I have af worksheet of 1000 rows with 5 colums. I have data in colum
B;E and would like Excel to format the rows in a colour depending of
what I write in colum A.

I have 5 different text imput I can chose for each row, lets call
them
"one"
"two"
"Three"
"Four"
"Five"

...just to keep this example as simple as possible.

If I write "one" in A2, I would like Excel to color Row 2 in one
color, if I write "Two" then another color and so on.

I found out how to color the cell I changed, but I would like to have
the whole row colored.

I hope someone can send me an example.

--
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please 
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will 
not get quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security 
measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.


--
To post to this group, send email to excel-macros@googlegroups.com




  -- 
  Sam Mathai Chacko
  -- 
  FORUM RULES (934+ members already BANNED for violation)
   
  1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
   
  2) Don't post a question in the thread of another member.
   
  3) Don't post questions regarding breaking or bypassing any security measure.
   
  4) Acknowledge the responses you receive, good or bad.
   
  5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
   
  NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
   
  
--
  To post to this group, send email to excel-macros@googlegroups.com

  -- 
  FORUM RULES (934+ members already BANNED for violation)
   
  1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
   
  2) Don't post a question in the thread of another member.
   
  3) Don't post questions regarding breaking or bypassing any security measure.
   
  4) Acknowledge the responses you receive, good or bad.
   
  5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
   
  NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
   
  
--
  To post to this group, send email to excel-macros@googlegroups.com




-- 
Sam Mathai Chacko
-- 
FORUM RULES (934+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor threa

Re: $$Excel-Macros$$ Conditional formatting of entire row using VBA

[Sam Mathai Chacko]

FJO, if you are using Excel 2003 or less, then I am afraid the solution I
posted will not be very useful, as it requires more than 3 conditionals,
which only Excel 2007+ supports.

So in that case, Don's VBA code should suit you fine. But if you are in
Excel 2007 or 2010, you could use multiple conditionals for formatting
(which is what I'd prefer, it also helps in reducing VBA)

Regards,
Sam

On Tue, Nov 15, 2011 at 10:35 PM, dguillett1  wrote:

>   Sam, I’m sorry.I opened in xl2003duh
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* Sam Mathai Chacko 
> *Sent:* Tuesday, November 15, 2011 10:51 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Conditional formatting of entire row
> using VBA
>
> Yes Don. I was just showing how it is done for one conditional. I had it
> done for One to Five in the attachment I had posted.
>
> Regards,
>
> Sam
>
> On Tue, Nov 15, 2011 at 10:07 PM, dguillett1  wrote:
>
>>   Sam,
>> > "one"
>> > "two"
>>
>> Don Guillett
>> SalesAid Software
>> dguille...@gmail.com
>>
>>  *From:* Sam Mathai Chacko 
>> *Sent:* Tuesday, November 15, 2011 10:21 AM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* Re: $$Excel-Macros$$ Conditional formatting of entire row
>> using VBA
>>
>>  Here's how you do it. Select your entire row. Assuming your top left
>> cell in the entire selection is A1 (will be any one cell in the first
>> column depending on where you started your selection)
>>
>> Go to conditional format, and in the options 'Use formula to determine
>> which cells to format', write =$A1="One"
>>
>> and then apply the required format you need.
>>
>> Check the attachment.
>>
>> Regards,
>>
>> Sam Mathai Chacko
>>
>> On Tue, Nov 15, 2011 at 7:19 PM, FJO  wrote:
>>
>>> Hi
>>>
>>> Can anyone help me with the VBA code for conditional formatting in
>>> Excel.
>>>
>>> I have af worksheet of 1000 rows with 5 colums. I have data in colum
>>> B;E and would like Excel to format the rows in a colour depending of
>>> what I write in colum A.
>>>
>>> I have 5 different text imput I can chose for each row, lets call
>>> them
>>> "one"
>>> "two"
>>> "Three"
>>> "Four"
>>> "Five"
>>>
>>> ...just to keep this example as simple as possible.
>>>
>>> If I write "one" in A2, I would like Excel to color Row 2 in one
>>> color, if I write "Two" then another color and so on.
>>>
>>> I found out how to color the cell I changed, but I would like to have
>>> the whole row colored.
>>>
>>> I hope someone can send me an example.
>>>
>>> --
>>> FORUM RULES (934+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5)  Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE  : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>>
>>
>> --
>> Sam Mathai Chacko
>> --
>> FORUM RULES (934+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 

Re: $$Excel-Macros$$ Conditional formatting of entire row using VBA

[FJO]

Hi Don Guillett

Thanks for your answer. It works perfect in the example. I then hoped
I could change a few things and the it would still work, but I can
not, and I can not see why.

Instead of writing "One", "Two" and so on in Colum A, I would like to
change this for different status, examples could be "Not started",
Awating info", "Finished"

I have tried to put these different status texts into the code, but
then it does not work. I am new to VBA, so I am sorry if this is
obvious to others.

Br. Finn

On 15 Nov., 17:21, "dguillett1"  wrote:
> Right click sheet tab>view code>insert this
>
> Private Sub Worksheet_Change(ByVal Target As Range)
> If Target.Count > 1 Or Target.Column <> 1 Then Exit Sub
> Select Case LCase(Target)
> Case Is = "one": x = 1
> Case Is = "one": x = 1
> Case Is = "two": x = 6
> Case Is = "three": x = 3
> Case Is = "four": x = 4
> Case Else
> End Select
> Rows(Target.Row).Interior.ColorIndex = x
> End Sub
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>
>
> -Original Message-
> From: FJO
> Sent: Tuesday, November 15, 2011 7:49 AM
> To: MS EXCEL AND VBA MACROS
> Subject: $$Excel-Macros$$ Conditional formatting of entire row using VBA
>
> Hi
>
> Can anyone help me with the VBA code for conditional formatting in
> Excel.
>
> I have af worksheet of 1000 rows with 5 colums. I have data in colum
> B;E and would like Excel to format the rows in a colour depending of
> what I write in colum A.
>
> I have 5 different text imput I can chose for each row, lets call
> them
> "one"
> "two"
> "Three"
> "Four"
> "Five"
>
> ...just to keep this example as simple as possible.
>
> If I write "one" in A2, I would like Excel to color Row 2 in one
> color, if I write "Two" then another color and so on.
>
> I found out how to color the cell I changed, but I would like to have
> the whole row colored.
>
> I hope someone can send me an example.
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
> not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
> ---­---
> To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com