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

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

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

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

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

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,

$$Excel-Macros$$ Conditional Formatting based on a Variable Cell

Hi, I'm working on a new project for a friend of mine. He's trying to track his "Support Activities." First I inserted this for counting cells: =B2*(COUNT(C2:I2)+COUNTIF(C2:I2,"x")+COUNTIF(C2:I2,"y")) Now there are sixty of these rows. B2 to B62 That works fine. However the problem is the

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

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

$$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 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 isk1...@gmail.com 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

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

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

Thanks On Sun, Jul 20, 2014 at 10:06 AM, Vaibhav Joshi v...@vabs.in 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

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

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 aaa222e...@gmail.com wrote: That' what i mean but i need t know how to do it because i will apply it to other file thanks

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 v...@vabs.in 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 aaa222e...@gmail.com wrote:

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 v...@vabs.in wrote: Check this!! Cheers! On Wed, Jul 16, 2014 at 8:47 PM, Ahmed Emam aaa222e...@gmail.com wrote: I have an excel sheet and i

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

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 by text And to be highlighted Blue if Cell B1 filled by text And to be highlighted

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

Re: $$Excel-Macros$$ Conditional formatting

[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

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

Re: $$Excel-Macros$$ Conditional formatting

whats issue? On Mon, Jun 16, 2014 at 11:12 AM, N.Shivkumar shiv1...@gmail.com 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:

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 amartak...@gmail.com 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 @

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

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 jcraig...@gmail.com wrote: Hello Forum. I use this forum extensively for review and research yet I have never submitted a question before so hopefully

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

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 fonb...@gmail.com 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

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

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 nicmo...@googlemail.comjavascript: wrote: Hi all, Using conditional formatting, how can I highlight the smallest-valued cell which is greater than 1.5?

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

Re: $$Excel-Macros$$ conditional formatting

try the attachement On Wed, Nov 27, 2013 at 3:14 PM, Rajesh Agarwal rajey...@gmail.com 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) !

Re: $$Excel-Macros$$ Conditional Formatting

in this case you want to highlight 1.571003 On Wed, Nov 27, 2013 at 2:45 PM, anon nicmorti...@googlemail.com 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 nicmo...@googlemail.com wrote: Hi

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

Re: $$Excel-Macros$$ Conditional Formatting

can u share a sample file On Tue, Nov 26, 2013 at 11:19 PM, anon nicmorti...@googlemail.com 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

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 pritiverma1...@gmail.comwrote: Hi Amar, you can use this formula in conditional formatingnew rule. =C31=INDEX($C$31:$J$38,MATCH($F$5,$C$31:$C$38,0),MATCH($C$4,$C$31:$J$31,0))

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

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 @

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

Hi Amar, you can use this formula in conditional formatingnew 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 amartak...@gmail.com

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

Re: $$Excel-Macros$$ conditional formatting

@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

FW: $$Excel-Macros$$ conditional formatting

@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.ukmailto:manjunath.narayana...@aon.co.uk wrote: Yes

Re: FW: $$Excel-Macros$$ conditional formatting

@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

$$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 manjunath.narayana...@aon.co.ukmailto:manjunath.narayana...@aon.co.uk wrote: Dear Abhi, Can I use formula

Re: $$Excel-Macros$$ conditional formatting

*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

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

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

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

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 amartak...@gmail.com wrote: Hi Anoop Thanks very much for solution but

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 aks.sharm...@gmail.comwrote: =IF(B2$A$2,↓,IF(B2$A$2,↑,↕)) -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM

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 aks.sharm...@gmail.comwrote: Please find attached. I hope this can help you. Regards, Anoop Sr. Developer On Wed,

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 amartak...@gmail.com 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

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

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

Re: $$Excel-Macros$$ Conditional formatting

check the attachment On Fri, Nov 9, 2012 at 9:55 PM, Shiva Prasad shivaprasad1...@gmail.comwrote: 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

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

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 shivaprasad1...@gmail.comwrote: Dear Champs, i have on excel one sheet when i mentioned values of percentages change the color of that cells. please

Re: $$Excel-Macros$$ Conditional formatting

Please see the attached sheet Aamir Shahzad On Fri, Nov 9, 2012 at 9:59 PM, Excel Beginner excelbegin...@gmail.comwrote: Hi shiva, please find the attachment. -- *Regards,* * * *Excel Beginner* * * On Fri, Nov 9, 2012 at 9:55 PM, Shiva Prasad

$$Excel-Macros$$ conditional formatting

*Hi Smitha* * * *Pl try this...* * * *With regards, **Pravin Gunjal** * * * -- Forwarded message -- From: Smitha S R sperdwo...@gmail.com Date: Mon, Aug 20, 2012 at 4:59 PM Subject: Re: $$Excel-Macros$$ conditional formatting To: excel-macros@googlegroups.com The colour should

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 sperdwo...@gmail.commailto:sperdwo...@gmail.com Date: Mon, Aug 20, 2012 at 4:59 PM Subject: Re: $$Excel-Macros

Re: $$Excel-Macros$$ conditional formatting

:* $$Excel-Macros$$ conditional formatting ** ** *Hi Smitha* ** ** *Pl try this...* * * *With regards, **Pravin Gunjal* ** ** -- Forwarded message -- From: *Smitha S R* sperdwo...@gmail.com Date: Mon, Aug 20, 2012 at 4:59 PM Subject: Re: $$Excel

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

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 sperdwo...@gmail.com 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 @

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 sperdwo...@gmail.com wrote: HI, some one please help me on this. On Mon, Aug 20, 2012 at 12:20 PM, Smitha S R sperdwo...@gmail.com wrote: Hi, If one cell

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 koul.ash...@gmail.com 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,

Re: $$Excel-Macros$$ conditional formatting

please help me On Mon, Aug 20, 2012 at 1:59 PM, Smitha S R sperdwo...@gmail.com 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 koul.ash...@gmail.comwrote: select range a2:d2 then use

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 naukrikuld...@gmail.comwrote: Dear Smitha, Please try this. (Sheet - 1 Sheet - 2) Regards, Kuldeep Singh

$$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 StockVerification Stock green colour should be

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 sperdwo...@gmail.com wrote: Hi, Please help in conditional formatting or use of if formula in the following case. Excel attached. Closing Stock Verification stock

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

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

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 drdeva...@gmail.com wrote: Dear Experts, I have attached

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 noorain.ans...@gmail.comwrote: Dear Deba, See attached Sheet. for Red you use.. =Hour($A1)4 and for yellow =Hour($A1)4 -- Thanks regards, Noorain Ansari

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

$$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 praveshkash...@gmail.com wrote: HI, Please

Re: $$Excel-Macros$$ Conditional formatting

Hi, Please Help. On Sat, Feb 18, 2012 at 12:38 PM, PRAVESH KUMAR praveshkash...@gmail.comwrote: HI, Please help...for conditional formatting PFA attached file Thanks Pravesh Kashyap -- FORUM RULES (986+ members already BANNED for

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 praveshkash...@gmail.comwrote: Hi, Please

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 idforex...@gmail.com wrote: Dear, Hope you are stuck in blank cells formatting, this can be done as follows, In Excel 2007, Conditional formatting =

Re: $$Excel-Macros$$ Conditional formatting

Plz see the attached        From: PRAVESH KUMAR praveshkash...@gmail.com To: excel-macros@googlegroups.com Sent: Saturday, 18 February 2012 12:38 PM Subject: $$Excel-Macros$$ Conditional formatting HI, Please help...for conditional formatting

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 darwin.chankaw...@gmail.comwrote: Dear group, i have a workbook which is set as shared, however, i found it could not apply conditional

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 darwin.chankaw...@gmail.comwrote: Dear group, i have a workbook which is set as shared, however, i found it could not apply conditional formatting. Could anybody

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

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

Re: $$Excel-Macros$$ Conditional formatting

Pls find attached file. On Sat, Feb 18, 2012 at 12:38 PM, PRAVESH KUMAR praveshkash...@gmail.comwrote: HI, Please help...for conditional formatting PFA attached file Thanks Pravesh Kashyap -- FORUM RULES (986+ members already BANNED for violation) 1) Use

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 bittu.ro...@gmail.com 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

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

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

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

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://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Wed, Dec 7, 2011 at 11:06 AM, George

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

Dear George, Consider this one. On Wed, Dec 7, 2011 at 11:06 AM, George Barrowcliff irvinep...@gmail.comwrote: 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

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

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

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

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

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

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 how you do it. Select your entire row

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

*From:* Sam Mathai Chacko samde...@gmail.com *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

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

  1   2   >