>
> http://tutorialway.com/use-named-range-in-excel/
>
useful website
--
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 th
http://tutorialway.com/conditional-cell-format-in-excel/
> http://tutorialway.com/conditional-cell-format-in-excel/
>
>
--
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.c
http://tutorialway.com/conditional-cell-format-in-excel/
visit this website for answer
--
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 con
>
> http://tutorialway.com/conditional-cell-format-in-excel/
useful website for answer
--
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 co
During testing I changed data in cell A1 of attached Sheet. Please assume
A1=50 then text written in attached sheet will give true picture of my
query. In short, I want that if value in B1 is => A1 then conditional
format should make it ticked with OK, if B1<= A1 then ticked with sign !
otherwi
Hi JCraig,
First of all, sorry for late response.
My approach relies on creation of a helper column. In that column you
should write this formula =g2&h2 and copy it down. Next select your data
and click on conditional formatting. Manage rules. Use a formula to
determine which cells to format.
Dear JCraig,
download your spreadsheet this site:
http://www.sendspace.com/file/box6mv
Basole.
Em quarta-feira, 15 de janeiro de 2014 18h35min23s UTC-2, JCraig escreveu:
>
> Hello Forum.
> I use this forum extensively for review and research yet I have never
> submitted a question before s
Hi, find in google for Winrar program to descompact the .rar file
On Thu, 16 Jan 2014 11:20:21 -0200, excel-macros@googlegroups.com wrote:
> Hello!
>
> I would love to see this but am unable to open a .rar file extenstion.
> Suggestions?
>
> J
>
>
>
>
> On Wednesday, January 15, 2014
Hello!
I would love to see this but am unable to open a .rar file extenstion.
Suggestions?
J
On Wednesday, January 15, 2014 7:13:04 PM UTC-5, Basole wrote:
>
> Dear JCraig, see if this is and if the formatting agree.
>
> Basole
>
>
>
> Em quarta-feira, 15 de janeiro de 2014 18h35min23s UTC
SURE! Thanks for reading over my post. You are saving my life literally!
A sample of the desired result has been attached as requested.
If you see the grouped values in column H (course#):1, 602 and 0006_82
for instance, and look at the corresponding rows in Column G (description),
the d
Dear JCraig,
Please could better elaborate your question including some lines manually
with the desired result
rgd,
Basole
Em quarta-feira, 15 de janeiro de 2014 18h35min23s UTC-2, JCraig escreveu:
>
> Hello Forum.
> I use this forum extensively for review and research yet I have never
> su
You need to create two conditional formats, one for the up arrow and one
for the down arrow.
In Excel 2010:
For the up arrow:
Select the range starting on cell L7
Go to Home -> Conditional Formatting -> New Rule -> Use a formula to
determine which cells to format
Write =L7>=$S$2 on the 'Format
Dear Noorain Sir,
Thanks a lot :)
Thanks & Regards
Abhishek
On Thu, May 24, 2012 at 11:17 AM, NOORAIN ANSARI
wrote:
> Dear Abhishek,
>
> Please see attached sheet with Sample Data.
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
Dear Noorain Sir,
it's not working
kindly please send me some sample data in excel sheet
Thanks & Regards
Abhishek
On Wed, May 23, 2012 at 5:55 PM, NOORAIN ANSARI wrote:
> Dear Abhishek,
>
> Please find attached screen shot,
>
> Hope it will help to you.
>
>
> On Wed, May 23, 2012 at 5:22 PM
I'm not sure that it's possible with xl 2003 because the conditionnal
formating must be the same as the range of apply.
In xl 2007 and 2010, you can make a test to a range of cell (O2:AS2 in
your example) and apply the result to O3:AS11.
The conditionnal formating has changed a lot with the new ve
I can help you with this later today, but, i need more info. I'm
assuming you want to do this in a macro. what does b/w mean?
Send me a sample of the speadsheet or just an email to
i...@millsproducts.com and I will try to help.
Bill Anderson
IT Administrator
Mills Products, Inc
www.millsproducts.
Hi Alvin,
I uploaded an example/explanation of what I'm trying to do. The file
is called EXCEL_SPREADSHEET.xlsx in the file section. Not sure how to
upload it to this message..
Thanks,
Kristin
On Jun 15, 9:35 pm, fongie wrote:
> Hi Kristin,
>
> Have you got an email I can send a file sample
Hi Kristin,
Have you got an email I can send a file sample to? I cant seem to
attached a file in here.
Alvin
On Jun 15, 2:32 am, Kristin wrote:
> I am trying to create 3 columns for an ongoing monthly master
> spreadsheet. The data includes: Product Name (highest level of info),
> Product I
easy piece...
Sub Kleur()
Dim oCel
For Each oCel In Selection
If oCel.Interior.ColorIndex = 36 Or oCel.Interior.ColorIndex = 38
Then
oCel.Value = "N"
End If
Next
End Sub
enjoy ...
Paul Willekens
--
--
So
Hi Keith,
The files can only be send via emails which attaches to it automatically.
Best Regards,
Ayush Jain
On Wed, Feb 17, 2010 at 6:05 PM, wrote:
> Yes it did thanks. I was wondering if you had the option of attaching files
> to thread so everyone on group could see progress of solution.
>
Hi Keith,
Would you please send the Excel file where the changes are required ?
Best regards,
Ayush Jain
On Feb 15, 7:41 am, Keith wrote:
> 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
Hi Ken,
I can't find the Paste line in your code, but I'm sure it's there somewhere.
Instead of paste, use Paste Special, then values. Then the formatting of the
destination cells will survive.
You can get the syntax by using the macro recorder.
Regards - Dave.
__
the Paste function copies the entire cell (or cells)
including all formatting.
try recording a macro to PasteSpecial Values:
Selection.PasteSpecial Paste:=xlPasteValues, _
Operation:=xlNone, _
SkipBlanks:=False, _
Transpose:=False
You can change it to
23 matches
Mail list logo
