| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Copying conditional formatting...HELP PLEASE!!!!
My original question was posted a few minutes ago (scroll down to see) & I
got the answer below but it didn't work....I'm about to SCREAM!!!! Can someone PLEASE help??? __________________________________________________ ____________ Hi Jason, I tried what you said but it is being stubborn & continuing to format the wrong cells! Any other ideas I can try??? Much Appreciated! __________________________________________________ _____ Using B$1 locks the row. Change it to B1. HTH Jason Atlanta, GA -----Original Message----- Desparately in need of help!!! What I am trying to do is find the conditional formatting that is going to highlight the "Not equal to" cells. In other words, below I have sample cell rows to the left (1,2,3,...), a column "A" and then I have two sets of matching #'s, one below another. I did a conditional formatting (from cell B2) that said "Cell Values is" "Not equal to" "=B$1"...I set it to highlight/shade when one of the two cells is not equal to the other. It works great for the 1st 2 rows...however when I do a paint formatting from B2 down to the rest of the row, it formats the wrong cells & every other cell highlights...In other words...B3 not equal to B2, B5 not equal to B4....and so on!!! PLEASE...I'm desperate.....can someone help!!! A 1 83543520 2 83543520 3 09341720 4 109341720 5 7503362001 6 7503362001 7 0501652001 8 0501652001 9 94485620 10 94485620 11 22122520 12 22122520 Expand AllCollapse All |
|
#2
|
|||
|
|||
|
Answered in your original post
-- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- <snip |
|
#3
|
|||
|
|||
|
trixiebme
I have just tried out what you described as being required and it works perfectly for me. ( I was already aware of the need to get rid of the $ before the row number to allow a format paint to be copied) You note that it does not work for you and you get every other row highlighted. I get rows 4,3,5,7,9 and 11 highlighted (which is every other line + line 4) I suspect you are having a problem with deciding what question you want answered. What you are getting is the first of repeated values shaded the rest being plain You have (in your own terms) stated B1 contains the first data item If data B2 is not equal to data B1 then colour B2 If data B3 is not equal to data B2 then colour B3 If data B4 is not equal to data B3 then colour B4 If data B5 is not equal to data B4 then colour B5 If data B6 is not equal to data B5 then colour B6 If data B7 is not equal to data B6 then colour B7 If data B8 is not equal to data B7 then colour B8 If data B9 is not equal to data B8 then colour B9 If data B10 is not equal to data B9 then colour B10 If data B11 is not equal to data B10 then colour B11 Note that cell B1 will never have CF as it is not compared with anything. To achieve this colouring enter the following CF in B2 'Cell Value is" not equal to =$B1 <then pick your shade/colour if true Cell B2 should remain uncoloured as B1=B2 Highlight Cell B2 <Format Paint Highlight B3 to B12 You will find 3,4,5,7,9,11 have taken the shading which agrees with what was asked for I hope this clarifies the problem for you. doncam65 "trixiebme" wrote in message ... My original question was posted a few minutes ago (scroll down to see) & I got the answer below but it didn't work....I'm about to SCREAM!!!! Can someone PLEASE help??? __________________________________________________ ____________ Hi Jason, I tried what you said but it is being stubborn & continuing to format the wrong cells! Any other ideas I can try??? Much Appreciated! __________________________________________________ _____ Using B$1 locks the row. Change it to B1. HTH Jason Atlanta, GA -----Original Message----- Desparately in need of help!!! What I am trying to do is find the conditional formatting that is going to highlight the "Not equal to" cells. In other words, below I have sample cell rows to the left (1,2,3,...), a column "A" and then I have two sets of matching #'s, one below another. I did a conditional formatting (from cell B2) that said "Cell Values is" "Not equal to" "=B$1"...I set it to highlight/shade when one of the two cells is not equal to the other. It works great for the 1st 2 rows...however when I do a paint formatting from B2 down to the rest of the row, it formats the wrong cells & every other cell highlights...In other words...B3 not equal to B2, B5 not equal to B4....and so on!!! PLEASE...I'm desperate.....can someone help!!! A 1 83543520 2 83543520 3 09341720 4 109341720 5 7503362001 6 7503362001 7 0501652001 8 0501652001 9 94485620 10 94485620 11 22122520 12 22122520 Expand AllCollapse All |
|
#4
|
|||
|
|||
|
All of you have been great for offering your help...however, you won't
believe why I couldn't do this...I was not selecting/highlighting both cells before painting!!! I was only selecting the cell where the condition was given! Something so simple took me ALL day to figure out & had everyone wondering why it worked for them and not me! Thanks again everyone... "Don Cameron" wrote: trixiebme I have just tried out what you described as being required and it works perfectly for me. ( I was already aware of the need to get rid of the $ before the row number to allow a format paint to be copied) You note that it does not work for you and you get every other row highlighted. I get rows 4,3,5,7,9 and 11 highlighted (which is every other line + line 4) I suspect you are having a problem with deciding what question you want answered. What you are getting is the first of repeated values shaded the rest being plain You have (in your own terms) stated B1 contains the first data item If data B2 is not equal to data B1 then colour B2 If data B3 is not equal to data B2 then colour B3 If data B4 is not equal to data B3 then colour B4 If data B5 is not equal to data B4 then colour B5 If data B6 is not equal to data B5 then colour B6 If data B7 is not equal to data B6 then colour B7 If data B8 is not equal to data B7 then colour B8 If data B9 is not equal to data B8 then colour B9 If data B10 is not equal to data B9 then colour B10 If data B11 is not equal to data B10 then colour B11 Note that cell B1 will never have CF as it is not compared with anything. To achieve this colouring enter the following CF in B2 'Cell Value is" not equal to =$B1 <then pick your shade/colour if true Cell B2 should remain uncoloured as B1=B2 Highlight Cell B2 <Format Paint Highlight B3 to B12 You will find 3,4,5,7,9,11 have taken the shading which agrees with what was asked for I hope this clarifies the problem for you. doncam65 "trixiebme" wrote in message ... My original question was posted a few minutes ago (scroll down to see) & I got the answer below but it didn't work....I'm about to SCREAM!!!! Can someone PLEASE help??? __________________________________________________ ____________ Hi Jason, I tried what you said but it is being stubborn & continuing to format the wrong cells! Any other ideas I can try??? Much Appreciated! __________________________________________________ _____ Using B$1 locks the row. Change it to B1. HTH Jason Atlanta, GA -----Original Message----- Desparately in need of help!!! What I am trying to do is find the conditional formatting that is going to highlight the "Not equal to" cells. In other words, below I have sample cell rows to the left (1,2,3,...), a column "A" and then I have two sets of matching #'s, one below another. I did a conditional formatting (from cell B2) that said "Cell Values is" "Not equal to" "=B$1"...I set it to highlight/shade when one of the two cells is not equal to the other. It works great for the 1st 2 rows...however when I do a paint formatting from B2 down to the rest of the row, it formats the wrong cells & every other cell highlights...In other words...B3 not equal to B2, B5 not equal to B4....and so on!!! PLEASE...I'm desperate.....can someone help!!! A 1 83543520 2 83543520 3 09341720 4 109341720 5 7503362001 6 7503362001 7 0501652001 8 0501652001 9 94485620 10 94485620 11 22122520 12 22122520 Expand AllCollapse All |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying cells with conditional formatting | Excel Discussion (Misc queries) | |||
| Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
| copying conditional formatting | Excel Worksheet Functions | |||
| copying conditional formatting to an entire column | Excel Discussion (Misc queries) | |||
| COPYING CONDITIONAL FORMATTING TO A COLUMN | Excel Worksheet Functions | |||
Linear Mode
