>
> 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
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 @
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
>
> 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
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 !
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 =g2h2 and copy it down. Next select your data
and click on conditional formatting. Manage rules. Use a formula to
determine which cells to format.
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-2,
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 7:13:04 PM
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 so
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
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
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
noorain.ans...@gmail.comwrote:
Dear Abhishek,
Please see attached sheet with Sample Data.
--
Thanks regards,
Noorain Ansari
www.noorainansari.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 noorain.ans...@gmail.comwrote:
Dear Abhishek,
Please find attached screen shot,
Hope it will help to you.
On Wed, May 23,
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
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
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 alvin.c.s.f...@gmail.com wrote:
Hi Kristin,
Have you got an email I
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 kristinmene...@gmail.com wrote:
I am trying to create 3 columns for an ongoing monthly master
spreadsheet. The data includes: Product Name (highest
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
--
--
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, dkb...@gmail.com 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
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 dkb...@gmail.com 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 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
22 matches
Mail list logo