Over 1 million tech questions and answers.

Solved: Excel: Formula to check cell color highlight?

Q: Solved: Excel: Formula to check cell color highlight?

What can I use (formula, etc) to check if a cell has a fill color or not? I have thousands of records with some with a yellow fill color. I need to move those that are filled to another sheet.

RELEVANCY SCORE 200
Preferred Solution: Solved: Excel: Formula to check cell color highlight?

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Solved: Excel: Formula to check cell color highlight?

Read other 8 answers
RELEVANCY SCORE 101.6

When I click into the formula bar, it usually color-codes the cells that are part of the formula.

Is there a point where the formula is too large and therefore it doesn't color-code the cells?

I realize that it doesn't color-code cells when you're calling information from other sheets....and that it doesn't color-code if your code contains errors and therefore won't computer....

...but when I press enter, the code "compiles" and has the correct result.

I'm just wondering, because it's helpful to have that color-coding of cells when you click the cell name in the formula and need to know where that cell is in a table.

Thanks,

Tim
 

A:Excel 2010 Cell Color-Coded by Formula

Alright...accidentally found something out without intending to.

If you put an ' before a cell number at any point before a "certain point", all cell names before that are color-coded. Once you reach a certain point (I'm assuming it's the point where Excel says there are too many cell calls to color-code them all - even if they're repeating calls to the same cells as above with different conditions) if you put the ' in, it won't show any color-coding.

There are no errors at this point...I checked. I'm assuming it's just because Excel has a number of cell calls at which it stops color-coding.
 

Read other 1 answers
RELEVANCY SCORE 93.2

In range A2:A11 I have a range of numbers .
What I want is for a CF or code that would find the highest number in that range and hightlight it in say green and also the full row that contains this highest number.

Have tried this CF formula , based on a google search
=A1=MAX($A1:$A11)

Result is only cell in column A is highlighted (say A6) and not the whole of row 6.

Any suggestions welcome

Pedro
 

A:Solved: Highlight whole row depending on 1 cell ,excel 2003

Read other 7 answers
RELEVANCY SCORE 91.2

This is a reopening of another thread. I still have not found any answers that help. And we won't discuss the lack of support from MS.

I am running Windows XP, Excel 2007.

I have noticed the problem with extremely light shading in xp-excel. It makes things especially difficult when selecting multiple, remote cells or text using the 'ctrl' function, as you cannot see which section has been highlighted or not (note, many people do not understand the nature of the problem as when selecting one cell/group of cells there is a box around the selection, making it easier to visualise, however in selecting many cells, there are no boxes to assist).

I work with spreadsheets constantly and need to highlight for deleting purposes and this is giving me headaches, etc.

Thank you.
 

A:Solved: Excel Selection highlight color

Read other 16 answers
RELEVANCY SCORE 87.6

Hello,

I am desperately trying to figure out how to select a cell with a formula. For example, I'd like cell [B,i] to have the value of cell [C, 15*i]
The cell formula would roughly look like : =C[15*this_line].

Has anyone an idea on how to do this properly on excel (got excel 2007) ?

Any help would be appreciated !
 

A:Solved: Excel : selecting a cell with a formula

Take a look at the Indirect function in Excel.

Regards,
Rollin
 

Read other 3 answers
RELEVANCY SCORE 86.4

=IF(AND(H73>=(H9-H11),H74<=(H9+H10)),"OK","Not to Print")

Using the formula above, when all cells 9 thru 11 are blank, the formula is outputting OK as the solution. I would like the formula to output nothing in that situation and leave the cell blank. How do I achieve this?
Thanks in advance
 

A:Solved: Excel - need formula to leave cell blank

Read other 7 answers
RELEVANCY SCORE 86.4

I have a large workbook (over 4 meg) with multiple sheets and lots of formulas. Today, I was trying to change a cell formula and instead of placing the result in the cell, the formula was placed in the cell and displayed as text, complete with the '=' sign in pos 1. The Evaluation tool states that the cell contains a constant.

The following is an example. The original formula and the mod with the changed component in red.

Original cell formula: =SUM(INDIRECT("T$"&MATCH($V1265,$V$2:$V1265,0)&":T"&ROW())). The cell result is a number.

modified cell formula: =SUM(INDIRECT("T$"&MATCH($V1265,$V$1:$V1265,0)&":T"&ROW())) . The cell displays the formula, exactly as shown, as text and therefore no result.

Has anyone ever encountered this before and is there a solution?
Thanks, Tom
 

A:Solved: Excel 2003: Formula Cell Becomes Text After Mod.

Read other 7 answers
RELEVANCY SCORE 85.6

Hi all,
I have a friend who's having a problem with a macro and it's been WAY too long since I've worked much with macros so I told her to post here. She's intimidated by you guys so I told her I'd be her proxy, but I'll send her a link to the thread and try to flush her out if you need clarification. Basically, she has a pivot table which produces a grand total. When the pivot table is refreshed, the grand total cell reference can change (for example, from D16 to F23). She has a formula that finds the reference of the grand total cell:

=CELL("address",INDEX($B:$AZ,MATCH("Grand Total",$B:$B),MATCH("Grand Total",$B2:$AZ2)))

She would then like to have the macro select the grand total cell, based on the reference provided from the formula, so that the macro can continue on using that grand total cell reference. I'm sure I've made a mess of the question, so let me know if I'm not making any sense. Thanks!
 

A:Solved: Excel macro: selecting a cell from a formula reference

Read other 12 answers
RELEVANCY SCORE 84.8

sorry about that title, not sure how else to summarize it...

here's what I'm looking for - if it's even possible?

if I have a formula in a cell - IF(A1:A20>0,1,0)
how do I get the value that's greater than 0, rather than a 1 for true? in other words, I don't want a 1, I want the actual number/value (from a1-a20) that made the IF true?

thanks!
Ron
 

A:Solved: excel - how to retrieve contents of a cell found in a range in a formula

Read other 8 answers
RELEVANCY SCORE 84.8

Trying to pull the word "set" from a cell that has more words and characters than just "set. I also need it to account for variables such as lower case/upper case (i.e. SET, SeT, SEt, seT). The formula needs to pull the word "set", however it looks, into the adjacent cell, this way I can use the Sort tool to organize all cells.

I tried the INDEX formula, but it only looks for the word "set" without distinguishing it from the other characters.

I don't think the LEFT/RIGHT/MID functions will work, as the character count is going to be a variable from each cell (my judgment on these formulas is really shallow due to my lack of time to completely understand them).

Take a look at the attached spreadsheet and you'll see where I'm going.

Thanks in advance
 

A:Solved: Excel 2007 - Formula for Extracting Specific Characters from Cell

Read other 9 answers
RELEVANCY SCORE 84

This may be an easy one; I searched but couldn't find it.

I have a project name sheet1 in a workbook with a column of hyperlinks to the right of each project. When clicked, it highlights the cell in sheet 2 with the notes for that project.
I would like to make all the text on the notes sheet white, and when a cell is highlighted, have the font be a different color only then.
In other words, I need a way to make the highlighted (linked) cell stand-out from the page.
Sorry if this is really simple; I just can't figure out how to do it.
Thanks in advance.
 

A:Excel Text Cell Highlight Question

Read other 16 answers
RELEVANCY SCORE 83.6

HI guys,

I am using Microsoft Excel 2003 and am trying to create a scheduler for my work place.
What I have to do is allow the user to enter data in the input sheet (by input meaning Dates) and then accordingly scan the schedule sheet and find the date entered on the input sheet, following which print the appropriate schedule opposite that date for that particular project.

For Example .....
If a person is working on a project called apple in cell D (effectively making it the 3rd project in the list) and the user enters the project start and end dates as 5th June and 13th June. So what I have to do is scan the Schedule sheet for these dates and enter the appropriate text of Start and End before these dates in the D column (i.e under the respective project).

How to do this I am clueless as I am a complete idiot as far as excel is concerned. SO any idea or any sort of help as to how this can be achieved will help.

The sheet must be automated as far as possible and there are about 25 to 30 projects which need to be updated into the sheet before the final output.

Thanks in advance.
 

A:Solved: Formula to find a date and enter schedule in a specific cell in Excel

Read other 13 answers
RELEVANCY SCORE 83.6

I would like to know if there is a formula that you can use to read if another cell has a color in another excel document.

Example:

Sheet1
i have A1 that is normaly Grey (red:216,green:216,blue:216)
When im done with A1 its green (Red:146,green:208,blue:80)
Normaly it takes a few weeks before im down with that cell

Sheet2
A1 I have 50% and 100% to tell me if the A1 cell on sheet1 is finished or not.

I would like to know if there is a formula i can put into Sheet2 A1 to look at Sheet1 A1 and if its grey to put 50% and if its green to put 100%

Thanks for your help. Not sure if this can be done or not i tried to look on here and google it with out much luck.
 

A:Solved: Formula read a color? Excel 2007

Read other 7 answers
RELEVANCY SCORE 83.6

In Excel, can I use an IF statement to change the background color of a cell?
 

A:Solved: Excel cell color change using an IF statement

Read other 16 answers
RELEVANCY SCORE 82.8

Hi All

I want to change the color of a cell when it is highlighted or selected. i don't want to change the background color of the cell. does any one know how to do this? I've searched the menu's and have cum up stumped. Maybe there is a rule i could insert in to the page.

Thanks Chris
 

A:Excel highlight color

Read other 7 answers
RELEVANCY SCORE 81.6

I am writing VBA code in Excel that adds Comment Objects to cells depending on the content of those cells.

When the comment is added a red triangle indicator appears in the upper right corner of the cell.

Is it possible/How can I change the color of those indicator triangles on a cell-by-cell basis?

I have a feeling that this is not possible but I thought I'd ask.

You can change the color of the error indicator triangles but you have to change all of them at once (can't change then cell-by-cell).

I can't find any reference to fill color of comment indicators.
 

A:Solved: How to change the color of the comment indicator in the corner of a Excel Cell

Built into Excel and cannot change.

However, as a workaround, you can draw triangle using AutoShapes over the comment indicators.

Hope this helps.
 

Read other 3 answers
RELEVANCY SCORE 78

Is there a way to control another cells value without putting the formula in that cell? For instance: I want cell A1 to have the formula: =If(A2)="Y",[make cell A3 = "Y"], "". Cell A3 will also have data validation in it containing, Y, N, M, R. Will that throw things off either?

Thanks!
 

A:Control different cell with formula in Excel

Not without VBA coding.
Why don't you want the formula in that cell?
 

Read other 1 answers
RELEVANCY SCORE 78

Is there a way to create an Excel formula that will test another cell for a formula or a value? I need a way to flag cells that have their formula replaced by a number, using the "conditional formatting" function. Trouble is, I can't figure out a way to test for this condition. Help!
 

A:Test for formula in cell in Excel

Read other 8 answers
RELEVANCY SCORE 78

I am currently using the formula =SUM(B3*140%) to get a mark-up of 40% when entering a price, but I would like to round this up to the nearest 0.50. Please see spreadsheet attached.
Is there anyway to add this formula along with the current one?
 

A:Multiple Formula's In One Cell | Excel

try
=CEILING(SUM(b3*140%),0.5)
 

Read other 2 answers
RELEVANCY SCORE 77.2

Hiya,

I'm having to make a list of users that we have but I need to put in name and login for example

Matt Hobbs | Mhobbs

Is there a forumla that I can use to read Cell A1 (Matt Hobbs) to display Mhobbs? so read the first character of the first word, then read the whole of the second word within a cell? - I've got no idea if its possible or not.

Thanks,
Matt
 

A:Excel formula to read the contents of a cell

Hi Matt, try this formula in B1
Code:

=LEFT(A1,1) & RIGHT(A1,LEN(A1) - FIND(" ",A1,1))
 

Read other 3 answers
RELEVANCY SCORE 77.2

How can i represent a blank cell in an excel formula ?

I'm trying to use a fomula such as

IF(<condition> ; <value1> ; <blank> )

If my condition is FALSE, I want the result to be a blank cell.

I tried inserting the number zero and the text string "", but they don't do the trick. In both cases , ISBLANK() returns FALSE on the cell.

I would like to know what I should use on the <blank> spot in my formula to obtain a cell, that will return TRUE in the ISBLANK() function.
 

A:How to represent a blank cell in an excel formula ?

How can i represent a blank cell in an excel formula ?

I'm trying to use a fomula such as

IF( CONDITION ; VALUE1 ; BLANK )

If my condition is FALSE, I want the result to be a blank cell.

I tried inserting the number zero and the text string "", but they don't do the trick. In both cases , ISBLANK() returns FALSE on the cell.

I would like to know what I should use on the BLANK spot in my formula to obtain a cell, that will return TRUE in the ISBLANK() function.
 

Read other 3 answers
RELEVANCY SCORE 77.2

Greetings all,

I am struggling to create a macro or function in Excel 2003 to return a formula to a cell based on a lookup criteria. I have tried vlookup and a few macros. There are a multitude of rows that makes this impossible to do by hand.

I have tried using a vlookup to return the formula as text then created a macro to sendkeys F2 and enter to each cell to activate the formula. That did not work.

I have also tried:
Function EvalFormula(FormulaCell As String)
EvalFormula = Evaluate(FormulaCell)
End Function
Can somebody help me or offer an alternative solution? My company will not allow me to attached any documents so I apologize that I don't have the specific problem in a spreadsheet.

Thanks in advance!

wirele55
 

A:Excel vlookup to return formula in cell

does this help
http://www.vertex42.com/ExcelArticles/evaluate-function.html

I have used with vlookup to look up a formula

see example attached

change the lookup value in B4 from test1 or test2
cell B2 then looks up the formula as text
the result is in A2

B1 is set to
=theresult

and the named range " theresult " does the evaluation of cell B2 = average or sum of cells m1.2.3 depending on lookup value and hence formula

how its down is with the link i sent - and detailed in cell a13,14,15
 

Read other 3 answers
RELEVANCY SCORE 77.2

I have been working on a new spread sheet for a little time now. The spread sheet takes data from a main table and uses it to create various other data tables to be used for different graphs. I have inserted a new sheet and have pasted a formula into a cell. when i copy this cell to another and try to edit the formula it displays the formula in the cell instead of the result.

Please help as it is rather important.
 

A:Excel. Formula appears in the cell, not the result.

Read other 12 answers
RELEVANCY SCORE 76.4

I am trying to trim the spaces from the data in a cell, but the function appears instead of the trimmed data. Here are the details: The contents of cell H9 is " 19004-2329". The contents of cell I9 is the function =TRIM(H9). The "Show Formulas in cells instead of their calculated results" variable in Excel Options is not checked. If I toggle CNTRL ` I can turn the "Show Formulas..." variable on and off, but the function remains in cell I9, instead of the resulting trimmed data. Any ideas on what else to try? Thanks.
 

A:Excel 2007 cell displays formula rather than result

Make sure the cell is not formatted as text.

Rollin
 

Read other 2 answers
RELEVANCY SCORE 76.4

This is my first post to this site

I am using Excel 2007. In cell A2 there is text with trailing char(160)'s in it. In cell A3 I type =substitute(A2,char(160),"") and when I press enter it displays the formula rather than the result.

I believe the original file was a xlsb, I saved as an xslx, but attained the same result. Don't know if file type is an issue.

Why does excel behave like this?

RAS7827
 

A:Excel 2007 cell displays formula rather than result

Try pressing CTRL+~ (Control and tilde) to see if that resolves the issue. It is a deliberate feature to allow you to edit the formulae more easily, also of great help to IT schoolkids who have to prove they put the formulae in by taking a screenshot.
 

Read other 1 answers
RELEVANCY SCORE 76.4

I imagine this is childishly simply if you know how but I have not been able to find any such thing in the help.

I have an MS Excel sheet (Office 2003) with
names in Column A,
titles in Column B, and
text in Column C.

In column D I want to enter a formula that will combine the text from columns A, B and C and insert a carriage return between each them (between A and B and between C and D).

Easy yes? But here are the rules for this problem:

1)The result *must* be an Excel worksheet formula that uses Excel worksheet functions, operators and/or literal strings. My own personal expectation is that the formula for cell D1 would look something like :
"= A1 & Something & B1 & Something & C1"

2) No macros allowed. No Visual Basic allowed. No cutting and pasting or converting back and forth between different applications. See 1 above.

3) The resulting text in column D must *appear* as though it has carrige returns between the lines... no little empty boxes indicating unprintable characters of the type that you get if you use Char(10) and/or Char(13) for "Something" in the example above..

4) No asking why I need to do it this way and saying I should do it some other way.

Please tell me what is the secret "Something" that I seek?
Does it exist?
 

A:Excel: how to specify insertion of a newline in text in a cell formula

Read other 8 answers
RELEVANCY SCORE 76.4

What formula do I use to return a cell reference instead of contents? For example if I have a list of 100 names in Column A and I'm looking for the value "horse" I'd like excel to tell me the value is in cell A42. What's the proper way to get this result?
 

A:Excel formula to return cell reference instead of contents

if the Cell you want to test is in B1
and then the lookup range is A1 to A450

If you put this into C1 - it will return the row - I have added the A as we know its column A

="A"&MATCH($B1,$A$1:$A$450,0)

i'm sure some of gurus will post a better solution
 

Read other 1 answers
RELEVANCY SCORE 76.4

Hi,
I've been asked to look into visually representing our storage locations in Excel.
In short, I have 1 Area containing 12 Locations. All but one of the Locations consist of several Rows, and each Row has a capacity, up to a max of 58 Units. The total Units is around 3,500.

I've been looking at using Conditional Formatting - particularly Colour Scales and Data Bars.
I'm now looking at an alternative to Data Bars.

In column A, I have a series of values - say 10, 20, 30, 40, [...] 100.
In column B I have the formula:

=REPT("&#9642;",A1)&REPT("&#9643;",100-A1)​
(obviously, replicated for the other values in A)
I'll also stick an IF ISERR on that in case someone enters a value above the max.
What I'm hoping to do is colour those black squares red, and leave the white ones untouched. I know I can't do this within the formula, or with the cond formatting, but I'm assuming it should be possible in code, using a Do Until loop or something?
It's just a demo, so I might use something other than the wee boxes in the end, I'm not sure yet.

My adventures in VBA are limited to recording macros or finding bits on the internet, and then jigging about with the code in the VBA window. It (pretty much) makes sense to me, but I wouldn't be able to write it from scratch.
Thanks in advance.

G
 

A:Excel 2007 - formatting part of a formula cell with VBA?

Read other 6 answers
RELEVANCY SCORE 76

In cell j, I have formula =IF(SUMPRODUCT(ISNUMBER(SEARCH("VLXP",K2:AB2))+0)>=1,"Yes","No") that returns yes or no if VLXP is contained in any cell K2 through AB2 and it works correctly. What I would really like to do is then put into cell j the entire matching cell content or if not found return n/a. Is there a way to accomplish this maybe with VBA?
 

A:Solved: Excel if cell contains vlxp then put matching cell data in current cell

Read other 6 answers
RELEVANCY SCORE 76

Hello This should be pretty strait forward, looking for a formula in Excel that lets me place a character in a specific cell, when placed it should highlight the row in a different color, yellow works

Is there any such formula?
 

A:Solved: Highlight Row Formula

Read other 8 answers
RELEVANCY SCORE 75.6

Is there a formula to make a cell change color when that cell has a specific numeric value? IE:

I have a small table. The total value column (say D5 - D10) is the cells I want to be color coded. D5 has the value 5. D6 has 6, D7 - 7, D8 - 8, D9 - 9, D10 - 10. Any cell that has a value of 5 and under is colored red, 6 - 8 is yellow and 9 and over is green so therefore D5 should be red, D6 to D8 is yellow and D9 - D10 is green.

Attached is an example.
 

A:Excel: value changes cell color

Under Format - Conditional Format

You should be able to accomplish what you need. It has 3 conditions to test for to apply your choice of cell format.
 

Read other 3 answers
RELEVANCY SCORE 75.6

Is it possible to change the color of a cell using a formula in Excel?
 

A:Cell color in Excel

Read other 13 answers
RELEVANCY SCORE 75.6

Hi,
I am having data structure as below. I need some macro or some means to populate formula in Column D based on column C (as and when it changes) . All other column data are populated. This is beyond me. Any help or direction is greatly appreciated. Thanks in advance

Col | A | B | C | D | E
------------------------------------------------------------------------
Row | 1 | Test1 | | | 10
| 2 | Test2 | =A1 | =MAX(E2) }| 15
| 3 | Test3 | =A2 | =MAX(E3) | 20
| 4 | Test3 | =A1&","&A3| =MAX (E1,E3)| 30
 

A:Excel macro or formula - change field based on other cell

Read other 7 answers
RELEVANCY SCORE 74.8

Hi everybody and greetings from Belgium:
I was wondering if anyone might know if there is any way to get excel to highlight the cells when it finds information I've asked it to via edit>find.
Because I have such big spreadsheets, with a lot of text, and numbers, I find it really hard to see where the "found" cell is.
Thanks in advance
Marbetu
 

A:Excel 2003, find function, highlight "found" cell?

Read other 7 answers
RELEVANCY SCORE 74

Here's a fun one.
I need to change the color of an Excel cell when a user selects it.

I have a spreadsheet which is a matrix of values 32cells by 30 cells. Users change the background color of a value when they have completed that task.

I would like the background(fill) to toggle between Grey and white when they select the cell. No other user entry is allowed and only the matrix cells will not be protected.

I think I need to create a function watching the onClick event but not sure.

Thanks for any guidance or help.
This needs to work on Excel 97 or greater.

Cheers,
Hammertime
 

A:Toggle Excel Cell color on click

>> onClick event

AFAIK there's no such thing for a worksheet. So firing an event when clicking a cell that's already selected could be a problem. There might be a workround but let's skip that for starters.

I'm confused that "No other user entry is allowed" yet users will be colouring (existing) values ; I guess you'd set up the values before issuing the sheet, and possibly set data validation of zero string length (NB - dv can be pasted over).

Try the below in the sheet module.

Rgds,
Andy

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim r As Range
With ActiveSheet
Set r = .Range("A1:AD32")
End With
If Selection.Cells.Count > 1 Then Exit Sub
If Not Intersect(Target, r) Is Nothing Then
ActiveSheet.Unprotect
If Selection.Interior.ColorIndex = 16 Then
Selection.Interior.ColorIndex = 0
Else
Selection.Interior.ColorIndex = 16
End If
ActiveSheet.Protect
End If
End Sub
 

Read other 3 answers
RELEVANCY SCORE 74

hi, i have 2-excel cells in the same sheet, both contain manually entered numbers; cell-2 changes frequently; if the existing entry in cell-1 is < than the new entry in cell-2, cell-1 should immediately reflect this new value. how do you create this formula?
 

A:Solved: excel-replace content of cell-1 if cell-2 is > cell-1

Read other 8 answers
RELEVANCY SCORE 73.2

I have a spreadsheet that has a hidden formula that colors the cells red if above the spec limit or yellow if below the spec limit. The author of the spreadsheet did not use "conditional formating" to color the cells when extracting data from a database. I want to change the color of the cells to make it easier to view. Can a command such as "Find & Replace" be used to change the color? I have been changing the cell color manually.
Thank you for your help.
 

A:Excel 2010 Cell Color Find & Replace

I have a spreadsheet that has a hidden formula that colors the cells red if above the spec limit or yellow if below the spec limit.Click to expand...

Is this VBA macro - how does it work - can you put a DUMMY DATA spreadsheet here to view
 

Read other 1 answers
RELEVANCY SCORE 73.2

I'm trying to write a macro for Excel 2010 to count cells only if the background fill color is a certain color. I'm having trouble finding how to access the background color information in Excel 2010.
 

A:Excel 2010 - Macro to count if cell is a certain color

Read other 6 answers
RELEVANCY SCORE 71.6

I have another problem similiar like menubar highlight tabs. This is when I right click on a empty webside and a drop down list comes up and the highlight is black. I want that to be yellow. This also apply for the menubar tab drop list as well. Anyone can help me with this please? Here is a screenshot what I'm talking about.

A:[SOLVED] right click highlight with mouse color

Hi again,

What do you think of the attached?
Are the colors what you want?

Read other 19 answers
RELEVANCY SCORE 70

Does anyone know of any way to add a check box to a cell in Excel 2002?

I need to be able to click on a box (or use the spacebar if using the keyboard) to add a check and then be able to sort the entries according to whether or not there is a check mark in the box.

We do not have Access, and I am trying to achieve this task without having to invest in Access. I currently have a column that I add an "X" to and sort that way, but I am looking for something easier.

It also needs to be compatible to Excel 2000, as some of our workstations still have that.

NOTE: If anyone can confirm absolutely that this can not be done, I would appreciate that as well.
Many many thanks!

-tim
 

A:Add a check box to an Excel 2002 cell?

It can certainly be done, Tim. But it's a lot more work.

You need to View-Toolbars, Control toolbox.

Use the checkmark from there.

Then you have to assign values to them and, I believe, you'll have to store those into a column anyway (maybe hide that column), and then sort that hidden column. Just like you're doing with the X's now.

Also, it'll require some VBA programming. I can't help with that part, but I'm sure someone will.
 

Read other 2 answers
RELEVANCY SCORE 70

I'm working on a spreadsheet at the moment which displays a range of cells all containing values referenced from another spreadsheet (within the same workbook). This system works fine.

Every day, the original worksheet is updated. So, it has fields already arranged up until the end of the year. A row for every date. Now, needless to say, rows for dates in the future contain no values, and so when the spreadsheet I am working on now references those cells, it displays "$0.00" (which is correct, given I am dealing with financial figures).

Now, all of that works as expected, however, on the spreadsheet I am working on, all of those figures are displayed in a line graph. This line graph, at todays date, shows an enormous drop given that the fields for the rest of the year all show a zero balance.

What I need to do, is to get the remainder of those fields (every field that says "$0.00") to not display anything at all. So, if the value is $0.00, it would not display a value at all, and therefore not show anything on the graph.

Can someone tell me how I can achieve this? I'm sure it can be done with an "if" statement, but I'm not sure how to structure it.

Any help would be greatly appreciated.
 

A:Solved: Remove Cell Value If Cell Value Is Zero (Microsoft Office Excel 2007)

=If(a1="","",Sheet1!a1) and drag it down.

Where a1 is the first cell in spreadsheet you are working on, and sheet1!a1 is the sheet within workbook containing figure.

Not sure if the graph will recognize the "blank' cell as blank or "0"
You could try that

Pedro
 

Read other 3 answers
RELEVANCY SCORE 69.6

I want to check column A rows 5-18 against a table in vba and if matches, insert DS into the cell. I have a list of names in A5-A18 and the days (1/1/12-6/3-/12) across the top in row 4. My IF is trying to check if colmun A name is equal to the Vlookup table for the matching date and Name2 (Date Day Name1 Name2). Any advise would be appreciated.
Code:

fRow = 4
fCol = 1
For iCol = 2 To 185
For iRow = 5 To 18
If Cells(iRow, fCol).Value = "VLOOKUP(cells(fRow, iCol),R1C201:R399C204,4)" Then
Cells(iRow, iCol) = "DS"
End If
Next iRow
Next iCol
 

A:Excel VBA Check if cellvalue = formula results

Read other 12 answers
RELEVANCY SCORE 69.2

I am trying to input a formula in a cell using the value within that cell. I've done this before and it worked, but now I can't seem to get it to work. What am I doing wrong?
Code:

Dim mrange As Range
Dim mcell As Range
Dim mval As String
Sheets("Step3").Select
Set mrange = Range("J12:J2000")

mrange.Select
For Each mcell In mrange
mval = mcell.Value
mcell.FormulaR1C1 = "=If(AND(Iserror(vlookup(RC-1,Listsource!R1C14:R100C15,2,FALSE))," & """" & mval & """" & _
",RC,(VLOOKUP(RC[-1],Listsource!R1C14:R100C15,2,FALSE)," & """" & """" & ")"
Next
 

A:Solved: VBA formula in cell

Few things
1. your brackets is not properly done.
eg where is you end bracket for AND function.

2. over use of double quote (")
when you shorten " & """" & mval & """", you end up with ""mval""

3. you have reference to RC which is a circular reference.
You can redo the formula in cells and use the immediate window to view the property
?activecell.formular1c1
 

Read other 1 answers
RELEVANCY SCORE 69.2

Please help me on how to put two formula in one cell.
here's my first formula
=IF(D6<C6,D6+1,D6)-C6
2nd formula
=COUNTIF(C66,"ABSENT")*0
My work sheet is all about getting number of hours work, and i want the word "absent" "off" to be counted as zero.
Im using excel 2010
 

A:Solved: Two formula in one cell

Read other 7 answers
RELEVANCY SCORE 68.8

Using Excel 2003 in Windows XP

I would like to use the contents of one cell as the destination location for copying data.
For example
I have 2 worksheets 1) Results and 2) info
in info
A1 = 'ABC'
C1 = 'Results!O54' < this is calculated based on other data in sheet.

Using a macro, I'd like to copy contents of A1 to cell location 'Results!O54' more specifically to where ever C1 points... C1 will change based on other data in info sheet.

The macro record for action looks like this (but I would like the 'O54' to be based on contents of C1 which changes)
Range("A1").Select
Selection.Copy
Sheets("Results").Select
Range("O54").Select
ActiveSheet.Paste
Sheets("info").Select

There is more to it then that but I think this is where I am stumped.
 

A:Solved: Excel: Uses contents of Cell to select a cell

Sheets("info").Range("A1").Copy Destination:=Sheets("Results").Range(Sheets("info").Range("C1").Value)
 

Read other 3 answers
RELEVANCY SCORE 68.4

I have a spreadsheet that contains formulas. I want a macro that will copy the data only in that cell with the formula and paste only the data in another cell.

I have been scratching my head for a little bit on this one.

Thanks
 

A:Excel - copying data and pasting data in a formula cell

If I understand correctly, you can actually avoid using copy altogether.

Let's say you have the value 50 in A1 and the formula =A1*2 in A2. The following macro would copy A2 to D2:

Sub Macro1()
Selection.Copy
Range("D2").Select
ActiveSheet.Paste
End Sub

but because the formula uses relative references, the resultant formula (in D2) would be =D1*2.

So what you could do instead -- using a single command only -- is:

Range("D2").Value = Range("A2").Value

HTH,
bomb
 

Read other 3 answers