Mark Dates With Colors
Nov 22, 2009i want to know how to mark the cells with color where the starting date is not greater than ending date.
View 4 Replies
ADVERTISEMENT
Mark Up In Advance The Dates Where I Get Paid
Nov 26, 2009I'm trying to mark up in advance the dates where i'll get paid. I get paid monthly on the 2nd last working weekday of the month. So because we have the 30/11/2009 falling on Monday of next week, my pay day for this month is Friday 28/11/2009.in December it should be the 30/12/2009.
I'm getting all tied up in Networkdays, EOm and weekday function!
Conditional Formatting :: Change Colors As Per Dates
Oct 23, 2009I’m sure conditional formatting is the way forward with this but can’t quite get the formula right. I need 2 columns: Column A will have dates that an event happened on. Column B will be blank until we have received back in a letter that went out on the date in column A. At which point the date the letter was received back in will be entered into column B
What I need is for the Colour of Column B to change from green (before and on the date of Column A) to Amber (for the next 3 days) and then red (from Day 5 onwards. This would be until a date was entered in column B (the date the letter is received back in) at which point it would just go back to white. This would keep a check on how long the letter was out for and whether we need to chase it up or not and with an increasing urgency.
Excel Pallet Lost Colors (hovering Displays Colors But Visual Clues Are Not Shown)
Jul 7, 2013My pallet lost color-coding - if I hover over each little scare it displays the names for the colors and if I click on them they color the cells with the right colors, but the palette itself lost the visual display of colors except for 8 colors: black, blue, red, magenta, yellow, cyan, and white.
I use color-coding of cells a lot and I find it difficult to work without visual clues. At least the hover-support allows me to get the work done, but with difficulty.
Mark Up Formula
Oct 1, 2007i have a project and i am making a spreadsheet for a make believe green grocers. i have a retail price and a whole sale price
to work out the retail price i need to sue this forumula
retail price = wholesaleprice + x% of wholesale price
im stuck, what i have done is declared the percent value on the page, which can be changed at any time, how do i then substitue this value in to the formula (and most importantly, what is the formula!)
How Do Mark All Posts?
Feb 26, 2009how and where to navigate on the website to mark all my posts solved. Sometimes I don't see the edit button, I don't know how to list all my posts, etc.
View 5 Replies View RelatedLook Into Another Workbook And If Value Is There - Mark As Yes
Jul 22, 2014I have two workbooks, lets say book1 and book2
In column A of book 1 i have a list of numbers, going down to A250
A1 = 23423423
A2 = 23442345
etc etc
I would like some code for a button press, if the value in A1:A250 is in book2 (A1:A250)
Both workbooks will be open at the point of the button press
then adjacent cell in B1:B250 is marked as Yes
Character Mark In A Box
May 23, 2008I've searched for this in the forums but can't find anything. I need to find/replace a character in Excel, it's a question mark in a box and looks like this
I've tried searching for special characters (using the ALT key and number pad) but I can't find anything matching this.
When I save the spreadsheet as a CSV (TAB delimited) this character gets picked up as a TAB, but when I try find replace on the TAB character it doesn't work!
I'm using Excel 2007.
Find And Mark
Mar 16, 2009I have to manually enter the code nos. of the hard copy to find the code in the soft copy. After finding the number, I wish to mark it as so that double work should not be done or to find which code's hard copy is not with me.
I am using Find and Replace to find the number and after it is found I have to click the replace tab to enter colour in it.
Is there any auto function to mark as soon as I find the required number instead of clicking the replace tab to save my time.
Mark Cell By Column And Row Value
Feb 2, 2014I have the following formula and need to incorporate that it is only a "B" if B20 also matches in named range "Breakdown_RSC"
Formula: ...........
I need the following section to take into account the data in B20 as in if it matches the data in the cell it should be a "B" in the cell.
Mark Intersection Of Two Items?
Mar 3, 2014I am making a rough gantt chart in excel for a project schedule. Japanese at work love excel fro some reason that is why I am trying to do this. I have column headings for days ( 3/3, 3/4, 3/5, etc) and I want to find a way to mark the intersection when a date is input in another row. I tried to do some conditional formatting using symbols, but couldn't get anything to work.
see picture. I want to mark at correct date according to column headings when date is placed in column E or F. This example shows column E with 3/10 so I want to make a value appear at intersection AS and the row 3/10 is on. Would like to get a symbol to appear there if possible.
excel help.png
Click And Mark A Cell With An X
Dec 18, 2008Is there a way to set a cell so if you click it, an "X" will be in the cell and if you click it again it will clear? Specifically I am looking to do this in the "1st Trip" column on the attached. I was going to use a check box but the appear to small and it does seems as though in Excel 2003 the size can be adjusted?
View 11 Replies View RelatedMark A Thread Closed?
Feb 13, 2009how do i mark a thread closed? I looked in tools and lots of other places?
View 4 Replies View RelatedMark Repeating Field
Dec 27, 2008I have a list of energy consumption records by address. The utility that supplied the data had to manually pull each record one by one from their 'database'. If two individuals shared one account, the record is repeated.
So, I have a 500,000 row table with some records with identical addresses and identical consumption amounts. How would I go about separating the duplicates (to then delete them)?
It's sorted by address then consumption. The logic is...
if the address value in column A repeats and the consumption field in column B also repeats, then...(place a marker in column C so I can sort and delete)
Cost Based Mark Up
Sep 26, 2007set up a cost based markup spreadsheet?
I need to be able to mark up values from 0.01-9.99 by 20% of their value, and 10.00 and above by 10% of their value.
I only know how to mark up values by a single percentage.
Find And Mark Duplicates
Dec 16, 2008I need to find duplicates subnet information in row F and mark the words "Duplicate"
Then I need to do the same with Row K. I need to find any duplicate subnet masks.
The reason for this is that I merged two orginizations into one spreadsheet and I need to find the duplicates in Company A and Company B's subnet and mask information.
Mark Formula Cells
Aug 14, 2009I have a problem - I wanna to mark (to colour) just cells which I use in formula is there any option for thise
If I have some table and I have formula =A1+B5+C7 I wana to colour just mentioned cells
Check For And Then Mark Duplicates
Aug 24, 2009I have a simple spread sheet, as shown below. Each line is on it's own row, and all the info on each line is in the first cell. (A1,A2,A3 etc....) What I require is a macro that will look at the "Code" line, take note of the code and if it finds a duplicate code number, mark the duplicate code with (1)....say up to (5).
In the case below, it would flag the second 07edr code and change it to 07edr(1). If there was a third 07edr code it would mark it 07edr(2) etc.
It needs to look at all the codes as it's possible there will be more then one set of duplicates.
Description = item 1
Code = 07edr
Quantity = 1
Description = item 3
Code = 08geo
Quantity = 2
Description = item 78
Code = 08cpm
Quantity = 1
Description = item 1
Code = 07edr
Quantity = 2
Description = item 39
Code = 16blf
Quantity = 1
Check Mark In Cell
Aug 22, 2007I inserted a check mark and tried to us a vertical lookup and post the check mark
All I get is a horseshoe looking character. When I do reference to the cell I get the same symbol. What I trying to do is to place a check mark by the items which have been approved. I know I could do it with an "X" or a color, but top management wants a check symbol. I am using Excel 2007
How To Mark All Rows Which Fall In One Of Ranges
Aug 15, 2014I have about 50 timespans.
Each is formatted to have start time in column A and end time in column B (DD/MM/YY h:mm).
I also have a list, with about 850 rows timestamped (same format).
I need to mark all rows which fall in one of the ranges.
How To Click A Cell That Will Automatically Mark With X
Jul 17, 2014I am creating a resource and I'd like the users of this resource to be able to click a cell which will then automatically come up with an x or similar symbol (tick?) and then if they click the cell again the x will disappear. Is this possible? I don't want a drop down box where they have to choose what they want, I want it to be an automatic action when the cell is clicked because there will be many cells that I will need to do this.
View 14 Replies View RelatedMacro To Mark Up A Complete Column By 10%
Dec 18, 2008i have a excel file i need to markup by a 10% value. It is the L column starting at row 2 till a varying number of rows. i need to mark up all of the rows in the spreadsheet. i do not know how to make it repeat.
This is the formula =L2*1.1(i think its the right one) but i do not understand how to make it repeat. any help would be greatly appreciated.
I need the value to be replaced with the marked up value.
Joining Two Cells Data With A X Mark In Between Them
Jan 28, 2013i have two entries in my excel sheet which i want to get noted in the other cell as follow
A B
1 ORDER NO. 480
2 GOODS 5
3 P.M 480X5
as my table have data in B1 AND B2 so i want B3 automatically becomes 480X5 so how can i do it
Comparing Columns And Mark Difference?
Oct 30, 2013When comparing collumns to find out if the values are the same or different I use this formula:
=IF((A2)=(B2);"same";"different")In some cases I see the results are not OK. I see the same values but the result states "different". This might be caused by spaces around the value that does not exist in the other cell I think.
File is attached, the green marking show what I expect to see, the yellow marking shows what puzzles me.
Using Cell As Checkbox (add Tick Mark)
Nov 13, 2008I need to click on a cell and when I click on it, it should change colour and insert a tick (or other symbol).
View 14 Replies View RelatedFind And Mark Data From One Sheet To Another
Feb 15, 2010look at the attached file. This might be the perfect job for a macro. I am trying to find the SKU's from sheet 1 in sheet 2 and subsequently mark the matching SKUs in sheet 2. Ideally, I would like the SKU's that could not be found to be set to Quantity "0"
View 2 Replies View RelatedCreate If Rule Of % Into Text Mark A B C
Mar 14, 2008Want to make an if rule where a student gets overall 75% in a column, then in another column next to that that would automatically give him a B or a B+ you know what I mean?
Hear are the ratios
A+ - 90-100
A - 80-89
B+ - 75-79
B - 70-74
C+ - 65-69
C - 60-64
D+ - 55-59
D - 50-54
E+ - 45-49
E - 40-44
and another one
Excellent - 80-100
Very Good - 70-79
Good - 60-69
Moderate - 50-59
Borderline - 40-49
How To Mark Subtraction Total As Red Text
Jan 21, 2013was wondering if it was possible to mark a text or cell as red every time a subtraction was made and also to show the total cell or text as red whenever a link is made ?
View 3 Replies View RelatedChange String Uppercase After Mark (Dot)
Apr 18, 2014how to make upper case after mark "." (dot), see this below :
sample data
after formula
Tabrani,Ny.yusmaniar
Tabrani,Ny.Yusmaniar
Badu Zai,Tn.surjaah R & Darussamin
Badu Zai,Tn.Surjaah R & Darussamin
Zainal Arifin,Ny.elvyati
Zainal Arifin,Ny.Elvyati
etc..
it's possible with excel code? if could perhaps not macro.
Fill Series With Adding Dot Mark
Jun 18, 2014How to make fill series number with simple excel formula, like table below :
col.a (desired result)
col.b
1.
john
2.
lia
3.
leo margarette
4.
david lee
etc....
note : not use Vba...