$$Excel-Macros$$ conditional formatting

Is it possible to name a conditional formatting style & then apply that to some selected cells. The cells are not contiguous, so can't select a bunch of them and apply. I guess a macro is needed? -- 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) !

$$Excel-Macros$$ Conditional Formatting

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

$$Excel-Macros$$ conditional formatting

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 ENVIRO

$$Excel-Macros$$ conditional formatting

: 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 mailto:manjunath.narayana...@aon.co.uk>> wrote: Dear Abhi, Can I use formula =IF(AND(A6=2,A7>

$$Excel-Macros$$ Conditional Formatting

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

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

$$Excel-Macros$$ Conditional formatting

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 erro

$$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 =TIM

$$Excel-Macros$$ Conditional formatting

I have a spread sheet with cells formatted to various colours depending on their value between upper & lower limits, so far nice & easy. However, when I use the "manage rules", I can't see these limits without going into "edit rule". Is there a way so that it displays the limits fully? See a

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

$$Excel-Macros$$ Conditional Formatting

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 th

$$Excel-Macros$$ Conditional Formatting

Dear Experts, I am still waiting for reply from you all. Please help me in this matter. Thanks Regards, Zafar Iqbal On Sat, Aug 27, 2011 at 10:29 AM, Zafar Iqbal wrote: > Dear Expert, > > Ref your instructions, please find attached file with conditional > formatting applied. My worry is about

$$Excel-Macros$$ conditional formatting

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 fille

$$Excel-Macros$$ conditional formatting

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

$$Excel-Macros$$ conditional formatting

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

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

$$Excel-Macros$$ Conditional formatting

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 fo

$$Excel-Macros$$ Conditional Formatting

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 b

$$Excel-Macros$$ Conditional Formatting

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

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

$$Excel-Macros$$ Conditional formatting

Hey dude. Just select all the cells . go to Conditional formatting -> manage rules->select new rule click on format only cells that contain "blanks " and click on format and select the white color. that's it. On 2/18/12, PRAVESH KUMAR wrote: > HI, > > > Please help...for conditio

$$Excel-Macros$$ Conditional formatting issue

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

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

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

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

FW: $$Excel-Macros$$ conditional formatting

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 mail

Re: $$Excel-Macros$$ conditional formatting

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

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

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

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

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

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

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

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

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

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

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

> 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

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

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

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

Re: $$Excel-Macros$$ conditional formatting

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

Re: $$Excel-Macros$$ Conditional Formatting

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

Re: $$Excel-Macros$$ Conditional Formatting

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 '

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

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

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

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

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

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

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

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

-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

wo...@gmail.com; excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ conditional formatting > > ** ** > > *Hi Smitha* > > ** ** > > *Pl try this...* > > * * > > *With regards, > **Pravin Gunjal* > > ** ** > > --

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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 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 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: FW: $$Excel-Macros$$ conditional formatting

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

$$Excel-Macros$$ Conditional formatting Excel 2002

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 s

$$Excel-Macros$$ Conditional Formatting VBA problem

Hi again group, I can't find a way to preserve the condtional formatting on a worksheet when rows are pasted from another sheet. The condtional formatting from the sheet that is being searched transfers to the destination sheet and overwrites or completely removes the condtional formatting rule

$$Excel-Macros$$ Conditional Formatting VBA problem

Hi again group, I can't find a way to preserve the condtional formatting on a worksheet when rows are pasted from another sheet. The condtional formatting from the sheet that is being searched transfers to the destination sheet and overwrites or completely removes the condtional formatting rule

$$Excel-Macros$$ Conditional Formatting Excel 2007

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

$$Excel-Macros$$ Conditional Formatting using VBA

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

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

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

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

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

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

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

t;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@g

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

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 li

$$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/exceldaily

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

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

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 hav

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

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

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

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 ex

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

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

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

  1   2   >