No announcements
Found 2892212 threads
-
0 VotesConditional Format copying from cell to different range
range with the ability to pass that formatting to the range value given in each cell. I have found numerous answers on how tocopy ...Answered | 2 Replies | 2523 Views | Created by wingrider54 - Thursday, January 31, 2013 9:25 PM | Last reply by Asadulla Javed - Friday, February 1, 2013 8:29 AM
-
1 Votes
Copying Conditional formatting from one range to another
range value given in each cell. I have found numerous answers on how to copy conditional formatting, but need to figure out how to ...Answered | 3 Replies | 1557 Views | Created by wingrider54 - Monday, February 4, 2013 7:12 PM | Last reply by Frank L. Smith - Monday, February 4, 2013 7:37 PM -
3 Votes
movable conditional format if cell is different from next cell to the right
I am trying to conditionally format cells if the text in them is not the same as the text in the cell to the right. If it matters or helps, last week's report ...Answered | 4 Replies | 1563 Views | Created by Dale2K9 - Thursday, December 27, 2012 8:35 PM | Last reply by Dale2K9 - Friday, December 28, 2012 4:03 PM -
0 Votes
define range using Cell Propety format
HI I have 2 sheets I want to be able to use variables to create the cell reference- one of the lines would ...Answered | 2 Replies | 684 Views | Created by David_1234 - Monday, April 22, 2013 4:53 PM | Last reply by David_1234 - Monday, April 22, 2013 8:26 PM -
0 Votes
Copying Format of a Range to another sheet in VBA
worksheets().range().copy 'Copies original data worksheets().range().select 'Select the NEW range to paste (may have ...Unanswered | 1 Replies | 4289 Views | Created by PartTimeProgrammer - Saturday, March 29, 2008 6:54 PM | Last reply by BleedBlueinFla - Thursday, April 3, 2008 2:54 PM -
0 Votes
conditional format
color the cell that contain the break time only, i can't use the conditional formatting as there is a color range between green and red color, but i need ...Answered | 3 Replies | 685 Views | Created by Ahmed M Abdel Kader - Tuesday, June 17, 2014 8:18 AM | Last reply by Fei Xue - Monday, June 23, 2014 8:27 AM -
0 Votes
SP 2010 Conditional Format, format selection
Set Style cell background value = Red Results: All items are highlighted in the Myname column whether they match or not. However, if I change ...Unanswered | 1 Replies | 7463 Views | Created by atek1 - Friday, October 22, 2010 1:03 PM | Last reply by atek1 - Tuesday, October 26, 2010 2:20 PM -
0 Votes
Copying conditional formatting
I want to copy a formula-based conditional format (CF) using Copy + Paste. Simple task, you would think. I have multiple blocks on my s/s, each consisting of ...Answered | 3 Replies | 2243 Views | Created by JP888888 - Tuesday, November 22, 2011 7:50 PM | Last reply by Laurent Couartou - Wednesday, November 23, 2011 2:30 PM -
0 Votes
Conditional Format formula incomplete
Conditional formatting formula is applied like cell formula and the excel adjusts similarly. Suppose in A1 you type =Sum(B1:C1) and paste to A10 then A10 you get formula ...Unanswered | 2 Replies | 1000 Views | Created by kblackie - Saturday, September 21, 2013 3:22 PM | Last reply by kblackie - Tuesday, September 24, 2013 4:22 PM -
1 Votes
Conditional Data Copying from Sheet to Sheet
I want to copy all the rows and columns where Name is "Andy" and "Sandy" to different sheets. so the sheet would look likeAnswered | 1 Replies | 864 Views | Created by StSingh - Sunday, August 11, 2013 9:35 PM | Last reply by Hans Vogelaar MVP - Monday, August 12, 2013 5:42 AM -
0 Votes
Copying rows conditional
Hi Dani5, Accoding to the description, you want to copy the rows based on the value on the sepcific cell. For achieve the goal, we can use Excel object ...Answered | 1 Replies | 418 Views | Created by Dani5 - Friday, April 3, 2015 3:51 PM | Last reply by Fei Xue - Monday, April 6, 2015 5:40 AM -
0 Votes
cell reference to range
Hi, I have a code piece like below. my need is to copy contents of some columns from shar_res file to other file. The headers are ...Unanswered | 1 Replies | 1099 Views | Created by Shriny01 - Thursday, November 8, 2012 9:21 AM | Last reply by Peter Thornton (Excel MVP 2008-13) - Thursday, November 8, 2012 10:40 AM -
0 Votes
Date Range Conditional Formatting
Hello, I am in need of a formula to use in a conditional formatting that would allow me to highlight/fill the cells on a rage of date and number values ...Answered | 1 Replies | 731 Views | Created by Databasico - Tuesday, June 25, 2013 10:04 PM | Last reply by The_Cosh - Tuesday, June 25, 2013 11:09 PM -
0 Votes
Apply Conditional formatting if cell contains formula
Conditional formatting with User Defined function(to check if cell has formula or value); but, adding User Defined function degrades the performance of the template. I ...Answered | 1 Replies | 4887 Views | Created by Haritha K - Thursday, July 23, 2009 7:55 AM | Last reply by Cindy Meister MVP - Monday, July 27, 2009 2:13 PM -
0 Votes
Excel cell format issue
After your code to change the format of your cell put the below for loop. I have assumed the range "B1:C10". you can change according to your ...Answered | 3 Replies | 692 Views | Created by HarishThirunahari - Tuesday, July 8, 2014 1:18 PM | Last reply by Vishwamitra Mishra - Wednesday, July 9, 2014 8:54 AM -
0 Votes
Copying text from range to range works but not formattedtext
setting these to Nothing doesn't seem to shield Office from needing repair. I, of course, cannot ask the customer to repair if something goes wrong ...Answered | 14 Replies | 7194 Views | Created by Michael M Fox - Saturday, December 11, 2010 3:34 PM | Last reply by Cindy Meister MVP - Tuesday, December 21, 2010 12:37 PM -
0 Votes
select a shape from particular range and then move that shape to different cell range
Re: move a shape You will have to know the location of the shape (cell address) or the name of the ...Unanswered | 1 Replies | 366 Views | Created by J_a_y_y - Tuesday, October 20, 2015 3:24 PM | Last reply by James Cone - Tuesday, October 20, 2015 11:25 PM -
0 Votes
How to copy format of one excel range to another with cell height and width of similar range?
copying the data without any format. I am afraid there is no object model to achieve your requirement ...Answered | 1 Replies | 409 Views | Created by Animesh.Dash - Monday, October 5, 2015 10:14 AM | Last reply by Edward8520 - Tuesday, October 6, 2015 6:57 AM -
0 Votes
Bug in setting conditional format in Excel2007 from VBA
Macro recording the interior of cell C1 is coloured green (per 5296274), as it's supposed to do. If I replay the macro on the same or a ... -
0 Votes
adding comments to cell range
can't we add comments for a range of cells sir. Is there possibility to add comments to active cell only. I need it in c# sir. thank ...Answered | 4 Replies | 2207 Views | Created by Shyamaldas - Thursday, February 16, 2012 9:36 AM | Last reply by h_schmieder - Monday, January 26, 2015 12:49 PM - Items 1 to 20 of 2892212 Next ›
No announcements
