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
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
>
> 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,
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
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
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
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
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
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
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:
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
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
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
Exactly and thanks for your reply
N.SHIVKUMAR
Mobile : +919422613567
Office : +912332301775
Alternate Email: shiv1...@yahoo.com
On 16 June 2014 11:54, Ravinder ravinderexcelgr...@gmail.com wrote:
PFA, if you are looking for this.
*From:* excel-macros@googlegroups.com
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:
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 @
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
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
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
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
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?
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) !
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
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
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))
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
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
@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
Value 0 to 2 = Green
Value greater than 2 = Red
Thanks
Manjunath
*From:* Abhishek Jain [mailto:abhishek@gmail.com]
*Sent:* 20 February 2013 08:59
*To:* Manjunath Narayanappa
*Cc:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ conditional formatting
Check
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
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
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
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
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,
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
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
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
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
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
-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
-Macros$$ conditional formatting
To: excel-macros@googlegroups.com
The colour should be filled in the whole row, not only in the cell.
The way suggested fill the colour in the cell only.
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
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 @
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
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,
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
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
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
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
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
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
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
Thanks rajan bro.
Thanks Regards,
*Deba Ranjan P*
On Wed, Jun 13, 2012 at 6:41 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
See the attached file
** **
* *
*Regards*
*Rajan verma*
*+91 7838100659 [IM-Gtalk]*
** **
*From:* excel-macros@googlegroups.com [mailto:
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
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
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 =
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
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
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
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
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
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
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
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
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
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
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
Right click sheet tabview codeinsert this
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count 1 Or Target.Column 1 Then Exit Sub
Select Case LCase(Target)
Case Is = one: x = 1
Case Is = one: x = 1
Case Is = two: x = 6
Case Is = three: x = 3
Case Is = four: x = 4
Case Else
End
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
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
*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
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
*From:* Sam Mathai Chacko samde...@gmail.com
*Sent:* Tuesday, November 15, 2011 10:51 AM
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Conditional formatting of entire row
using VBA
Yes Don. I was just showing how it is done for one conditional. I had it
done for One to Five
Hi Don Guillett
Thanks for your answer. It works perfect in the example. I then hoped
I could change a few things and the it would still work, but I can
not, and I can not see why.
Instead of writing One, Two and so on in Colum A, I would like to
change this for different status, examples could
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 goo...@finndj.dk wrote:
Hi Don
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
: Tuesday, November 15, 2011 11:38 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Conditional formatting of entire row using VBA
FJO, if you are using Excel 2003 or less, then I am afraid the solution I
posted will not be very useful, as it requires more than 3 conditionals
Rows(Target.Row).Interior.ColorIndex = y
End Sub
Don Guillett
SalesAid Software
dguille...@gmail.com
*From:* Sam Mathai Chacko samde...@gmail.com
*Sent:* Tuesday, November 15, 2011 11:38 AM
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Conditional formatting of entire
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 samde...@gmail.com wrote:
Here's
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
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 samde...@gmail.comwrote:
For that you'll have to first tell how your
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
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 xavierj...@gmail.com wrote:
Hi
I am xavier, new to this group. Please help me in conditional
hi prasad
pfa
On Fri, Oct 14, 2011 at 11:11 AM, Mr Excellent suryaprasad...@gmail.comwrote:
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
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
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
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 samde...@gmail.comwrote:
Goto VBE, insert a new module in your workbook vba project, and add
Dear Craig,
Please Try
Review-Track Change..
On Thu, Oct 6, 2011 at 2:29 AM, Craig Brandt craigbran...@gmail.com 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
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 craigbran...@gmail.com wrote:
Conditional Formatting Highlight of Changed Cells
I have a
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 http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
*
*
On Wed, Sep 7, 2011
OK, please see attachment.
zp18
On Thu, Sep 8, 2011 at 2:22 PM, Venkat CV venkat1@gmail.com 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,*
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 irvinep...@gmail.com wrote:
A1=the name of an employee, defined name is Suspect
A2= an
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 ziqba...@gmail.com wrote:
Dear Experts,
Still waiting for your kind support.
Regards,
Zafar Iqbal
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
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 irvinep...@gmail.com
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,
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 ziqba...@gmail.com wrote:
Dear Expert,
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 '
Select February – July data
First rule :
=(C2-B2)/B20.05 è Red
Second rule :
=AND((C2-B2)/B20,(C2-B2)/B2=0.05) è yellow
Third rule :
=C2B2 è green
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Jagadeesh B S
Envoyé : jeudi 4
Please see attachment.
On Thu, Aug 4, 2011 at 4:29 PM, Jagadeesh B S jagg...@gmail.com wrote:
Pdt Jan Feb March April May June July
A 0.52 0.60 0.60 0.71 0.71 0.66 0.00
B 0.72 0.72 0.71 0.86 0.96 0.81 0.77
C 3.84 4.35 4.39 3.88 4.23 4.06 3.69
D 1.16 1.49 1.49 1.49 1.67 1.92 0.00
Great info... Thanks for sharing keep it up..
On Tue, Nov 9, 2010 at 7:01 PM, Rajasekhar Praharaju
rajasekhar.prahar...@gmail.com wrote:
Conditional Formatting
You can use something called Conditional Formatting in your spreadsheets.
Conditional Formatting allows you to change
1 - 100 of 108 matches
Mail list logo