No announcements
Found 2897455 threads
-
3 VotesFORMAT CELLS IF VALUE IS ENTERED IN CELL!
What I want is: if a value is entered in cell A50 then underline row from A50 till Q50.Answered | 2 Replies | 548 Views | Created by VassilisTr - Sunday, August 3, 2014 9:31 AM | Last reply by VassilisTr - Sunday, August 3, 2014 11:30 AM
-
0 Votes
Format Cells on DataGridView
, you won't realize it until it is entered. Corrections become more tedious than they should be. Is there a way to apply the format when the cell ...Answered | 3 Replies | 503 Views | Created by wodders - Friday, January 16, 2015 7:49 PM | Last reply by wodders - Tuesday, January 20, 2015 3:45 PM -
0 Votes
i want to unlock cells a16:c43 only if any value is entered in cell K8
i want to unlock cells a16:c43 only if any value is entered in cell K8, please help me with this isuueAnswered | 12 Replies | 351 Views | Created by DEEPU1980 - Wednesday, February 22, 2017 1:36 PM | Last reply by Hans Vogelaar MVP - Thursday, February 23, 2017 4:08 PM -
37 Votes
lock Excel cell after value is entered
See httpsAnswered | 75 Replies | 49718 Views | Created by Rushdy Najath - Wednesday, March 28, 2012 10:50 AM | Last reply by Hans Vogelaar MVP - Tuesday, October 1, 2019 8:44 PM -
0 Votes
Format Cells(cell.Row, "N").Value
If the value in Column N is 5.00 the result with: Cells(cell.Row, "N").Value will be 5 How do I format it to ...Answered | 2 Replies | 1853 Views | Created by juanpablogallardo - Tuesday, February 7, 2012 10:20 PM | Last reply by juanpablogallardo - Tuesday, February 7, 2012 10:34 PM -
0 Votes
Change Spinner Min and Max Depending on Cell Value
1 OrUnanswered | 1 Replies | 2186 Views | Created by t0m46 - Friday, January 20, 2012 12:07 AM | Last reply by t0m46 - Friday, January 20, 2012 12:08 AM -
0 Votes
Excel - Copy Cells if Cell Contains Value to Sheet 2
BeginWith ' are included in the result. If EndsWith is not an empty string, only those cells ' that end with EndsWith are included in the result. ...Proposed | 1 Replies | 500 Views | Created by Dan_CS - Thursday, May 18, 2017 2:34 PM | Last reply by Chenchen Li - Thursday, May 25, 2017 8:12 AM -
0 Votes
Format Value On Datagrid cells
how to make the format value on the Datagrid cells... the format value is : 1,000,000 the sample above mean's that the numberAnswered | 1 Replies | 5697 Views | Created by Yosi Oliver - Thursday, February 12, 2009 3:57 AM | Last reply by Martin Xie - MSFT - Monday, February 16, 2009 8:07 AM -
0 Votes
Format Cell Value based on Format in Another Cell
number entered is formatted correctly. However, we are now seeing more and more users paste the data into the spreadsheet from another system. When this ...Answered | 2 Replies | 707 Views | Created by 2012S4 - Sunday, February 23, 2014 10:33 PM | Last reply by 2012S4 - Monday, February 24, 2014 1:40 AM -
0 Votes
automating cell if negative value is found
pls. help i had a text value in row A1 to A5 and number value in row B1 to B5 that represent A1 to A5, now my problem if cell ...Answered | 1 Replies | 3108 Views | Created by restyong - Thursday, May 24, 2007 2:10 PM | Last reply by XL-Dennis - Thursday, May 24, 2007 4:16 PM -
0 Votes
borders around cells if date in first cell using vba
Hello. I am trying to see if I enter a date in a cell in column B that the cells in that corresponding row to column S get a border around ...Answered | 2 Replies | 332 Views | Created by johnboy0276 - Sunday, May 17, 2015 3:10 PM | Last reply by johnboy0276 - Sunday, May 17, 2015 7:57 PM -
0 Votes
read cell value in HTML format
special character with all the data, i need to read the cell value into html, i mean i want that cell value in html format(string) how can ...Answered | 4 Replies | 5042 Views | Created by Mohammed Nayeem - Monday, December 6, 2010 6:28 AM | Last reply by Mohammed Nayeem - Friday, December 10, 2010 5:45 AM -
1 Votes
Lock excel cell after value is entered - share data?
That is exactly what they did. Thank you!Unanswered | 2 Replies | 320 Views | Created by SadieNegan - Wednesday, September 26, 2018 8:50 PM | Last reply by SadieNegan - Thursday, September 27, 2018 11:00 PM -
0 Votes
Retaining Focus in a Data Grid Cell if value is not given in that cell
Hi, I am using Component One Data grid in my WPF application.i want to retain focus in current cell if value is not ...Answered | 4 Replies | 527 Views | Created by Naseer83 - Wednesday, July 23, 2014 8:06 PM | Last reply by Terrence-Jones - Tuesday, July 29, 2014 2:40 AM -
1 Votes
VBA If statement using cells value
Hello all Im trying to setup a Configure Worksheet so user will not have to get into the vba code. Is the anyway of using the value in ...Answered | 3 Replies | 6029 Views | Created by Mike7952 - Sunday, June 24, 2012 8:51 PM | Last reply by Asadulla Javed - Tuesday, June 26, 2012 3:32 AM -
0 Votes
Clear Cells based on another cell value
validation drop downs. When a value is entered on the other tab that matches the VLOOKUP formula it returns a value to cell W2 then the code ...Proposed | 10 Replies | 594 Views | Created by KeDennis - Thursday, March 31, 2016 10:21 PM | Last reply by Deepak Saradkumar Panchal - Tuesday, April 5, 2016 7:41 AM -
1 Votes
Ensure unique value is entered in textbox
value entered by the user. previousIDS[x] = idNum; foreach (string num in previousIDS) ...Answered | 9 Replies | 1997 Views | Created by mallorz - Saturday, March 2, 2013 10:11 PM | Last reply by mallorz - Sunday, March 3, 2013 7:36 PM -
0 Votes
How to View Dependent/Precedent Cells of a Selected Cell in Flow Chart Format
I have a spreadsheet that uses various circular references that, once a cell in the circular reference cycle if changed, iterates to a certain value up to a ...Answered | 1 Replies | 1763 Views | Created by DakotaRoss - Tuesday, July 16, 2013 3:57 PM | Last reply by Johnny Comanche - Friday, July 19, 2013 7:48 AM -
0 Votes
Format Cells over a range
through the cells in the range, and then set or format for every cell. Here is a simple code to loop ...Answered | 2 Replies | 1353 Views | Created by Nejox - Monday, July 11, 2016 2:28 PM | Last reply by Nejox - Tuesday, July 12, 2016 2:27 PM -
0 Votes
Excel Cell format disregarded
entered 1 in the cell even though the Cell said zero decimal positions. I had to go to "Options, Advanced, Automatically insert decimal point and change it to ... - Items 1 to 20 of 2897455 Next ›
No announcements
