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

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 conditi

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

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 G

Re: $$Excel-Macros$$ conditional formatting

> > 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, accura

Re: $$Excel-Macros$$ Conditional Formatting

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 cel

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

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 :*

Re: $$Excel-Macros$$ Conditional Formatting for a cell based on another

Thanks On Sun, Jul 20, 2014 at 10:06 AM, Vaibhav Joshi wrote: > Just copy the cell in which you have applied conditional formatting, after > that select cells where you need to apply same formatting, then Paste > special formatting to it by right clicking on selected cells. > > Check this attac

Re: $$Excel-Macros$$ Conditional Formatting for a cell based on another

Just copy the cell in which you have applied conditional formatting, after that select cells where you need to apply same formatting, then Paste special formatting to it by right clicking on selected cells. Check this attachment. Cheers!! On Sun, Jul 20, 2014 at 2:51 AM, Ahmed Emam wrote: > I

Re: $$Excel-Macros$$ Conditional Formatting for a cell based on another

I applied the formula as you did to one cell, but now i want to apply it to a whole table as attached. I applied it to Cell C3 to be based on O, P, Q in the attached file. Now i want to apply it to the cell range from C3 to N3 and C22 to N22. Brief: the formula to apply on every row from C to N

Re: $$Excel-Macros$$ Conditional Formatting for a cell based on another

Cheers. . On Jul 18, 2014 4:50 PM, "Ahmed Emam" wrote: > Thanks for your support > > > On Fri, Jul 18, 2014 at 9:40 AM, Vaibhav Joshi wrote: > >> Hi >> >> Check conditional format set in sheet.. >> >> First select Cell A1, then conditional formting and Manage Rules... >> >> Cheers!! >> >> >> >>

Re: $$Excel-Macros$$ Conditional Formatting for a cell based on another

Thanks for your support On Fri, Jul 18, 2014 at 9:40 AM, Vaibhav Joshi wrote: > Hi > > Check conditional format set in sheet.. > > First select Cell A1, then conditional formting and Manage Rules... > > Cheers!! > > > > > On Fri, Jul 18, 2014 at 12:51 AM, Ahmed Emam wrote: > >> That' what i me

Re: $$Excel-Macros$$ Conditional Formatting for a cell based on another

Hi Check conditional format set in sheet.. First select Cell A1, then conditional formting and Manage Rules... Cheers!! On Fri, Jul 18, 2014 at 12:51 AM, Ahmed Emam wrote: > That' what i mean but i need t know how to do it because i will apply it > to other file > > thanks > > > On Thu, Ju

Re: $$Excel-Macros$$ Conditional Formatting for a cell based on another

That' what i mean but i need t know how to do it because i will apply it to other file thanks On Thu, Jul 17, 2014 at 10:03 AM, Vaibhav Joshi wrote: > Check this!! > > Cheers! > > > On Wed, Jul 16, 2014 at 8:47 PM, Ahmed Emam wrote: > >> I have an excel sheet and i want some cells to be highl

Re: $$Excel-Macros$$ Conditional Formatting for a cell based on another

Check this!! Cheers! On Wed, Jul 16, 2014 at 8:47 PM, Ahmed Emam wrote: > I have an excel sheet and i want some cells to be highlighted by some > colors if other 3 cells filled by text. > please see the attached example: > > What i mean that Cell A to be highlighted Yellow if Cell A1 filled b

Re: $$Excel-Macros$$ Conditional formatting

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@google

Re: $$Excel-Macros$$ Conditional formatting

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 Jun

RE: $$Excel-Macros$$ Conditional formatting

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 s

Re: $$Excel-Macros$$ Conditional formatting

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

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

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/discusse

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

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

Re: $$Excel-Macros$$ Conditional formatting

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

RE: $$Excel-Macros$$ Conditional Formatting

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

RE: $$Excel-Macros$$ conditional formatting

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

Re: $$Excel-Macros$$ Conditional Formatting

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 fo

Re: $$Excel-Macros$$ conditional formatting

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 offic

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

Re: $$Excel-Macros$$ Conditional Formatting

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,

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

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

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

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

Re: $$Excel-Macros$$ conditional formatting

6=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 &g

Re: $$Excel-Macros$$ conditional formatting

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

RE: $$Excel-Macros$$ conditional formatting

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

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

Re: $$Excel-Macros$$ Conditional Formatting

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

Re: $$Excel-Macros$$ Conditional Formatting

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 neu

Re: $$Excel-Macros$$ Conditional Formatting

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

Re: $$Excel-Macros$$ Conditional Formatting

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 Sha

Re: $$Excel-Macros$$ Conditional Formatting

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

Re: $$Excel-Macros$$ Conditional formatting

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

Re: $$Excel-Macros$$ Conditional formatting

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

Re: $$Excel-Macros$$ Conditional formatting

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:

Re: $$Excel-Macros$$ Conditional formatting

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.

Re: $$Excel-Macros$$ conditional formatting

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

RE: $$Excel-Macros$$ conditional formatting

-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$$ condi

Re: $$Excel-Macros$$ conditional formatting

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

Re: $$Excel-Macros$$ conditional formatting

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

Re: $$Excel-Macros$$ conditional formatting

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", t

Re: $$Excel-Macros$$ conditional formatting

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

Re: $$Excel-Macros$$ conditional formatting

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

Re: $$Excel-Macros$$ conditional formatting

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

Re: $$Excel-Macros$$ conditional formatting

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

Re: $$Excel-Macros$$ conditional formatting

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-

RE: $$Excel-Macros$$ conditional formatting

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 Ex

Re: $$Excel-Macros$$ conditional formatting

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.

Re: $$Excel-Macros$$ conditional formatting

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

Re: $$Excel-Macros$$ Conditional formatting

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 Cel

Re: $$Excel-Macros$$ Conditional formatting

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

Re: $$Excel-Macros$$ Conditional formatting

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)

Re: $$Excel-Macros$$ Conditional formatting

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

Re: $$Excel-Macros$$ Conditional formatting

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, acc

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

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 Ch

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

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

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

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 h

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

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, =Of

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

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

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

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

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

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

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

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, Georg

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

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

Re: $$Excel-Macros$$ Conditional formatting of entire row using VBA

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

Re: $$Excel-Macros$$ Conditional formatting of entire row using VBA

Case 5: x = "Five": y = 4 Case Else End Select Target = x Rows(Target.Row).Interior.ColorIndex = y End Sub Don Guillett SalesAid Software dguille...@gmail.com From: Sam Mathai Chacko Sent: Tuesday, November 15, 2011 11:38 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel

Re: $$Excel-Macros$$ Conditional formatting of entire row using VBA

Hi Sam I am aware of the possibilities in office 2007 and later. But this sheet will be used by multiple users, someone still in office 2003. Therefore I will save it in the old office format. I knew where to put Don's code, and that worked, but I then wanted to change the words the conditional f

Re: $$Excel-Macros$$ Conditional formatting of entire row using VBA

Don's code should be pasted in the sheet code module of the corresponding sheet that you are working on. Please check. By the way, you wouldn't need VBA for the desired feature if you are using Excel 2007 or greater. Sam On Wed, Nov 16, 2011 at 12:03 AM, FJO wrote: > Hi Don Guillett > > Thanks

Re: $$Excel-Macros$$ Conditional formatting of entire row using VBA

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 cou

Re: $$Excel-Macros$$ Conditional formatting of entire row using VBA

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

Re: $$Excel-Macros$$ Conditional formatting of entire row using VBA

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

Re: $$Excel-Macros$$ Conditional formatting of entire row using VBA

d 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

Re: $$Excel-Macros$$ Conditional formatting of entire row using VBA

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 ho

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

Re: $$Excel-Macros$$ Conditional formatting of entire row using VBA

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 C

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

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

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 refre

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

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 refresh

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

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 hav

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

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

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

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 us

Re: $$Excel-Macros$$ Conditional Formatting

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 C

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

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

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

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

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

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 >

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

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 >

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

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

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

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 * > *Chenna

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

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

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

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, defi

Re: $$Excel-Macros$$ Conditional Formatting

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

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

Re: $$Excel-Macros$$ Conditional Formatting

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

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

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

Re: $$Excel-Macros$$ Conditional Formatting

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, 201

Re: $$Excel-Macros$$ Conditional Formatting

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 instr

  1   2   >