If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Conditional formatting
Hi,
I need help I want to do the following thing in excel If i have to make condition for the selected cell that if any perticular cell is equal to something the selected cell should have some color, please let me know how i can do this? Thanks Vinit |
#2
|
|||
|
|||
Conditional formatting
Just copy and paste the below formula in any of the cell
="store.murpheythejeweler.com/store/p/"&7062+ROW(A1)&"-Tungsten-Flat-8mm-Polished-Band.aspx" Now place the cursor on the pasted cell and drag it for the remaining cells. Or Copy that cell and paste it for the remaining cells. If this post helps, Click Yes! -------------------- (Ms-Exl-Learner) -------------------- "Vinit" wrote: Hi, I need help I want to do the following thing in excel If i have to make condition for the selected cell that if any perticular cell is equal to something the selected cell should have some color, please let me know how i can do this? Thanks Vinit |
#3
|
|||
|
|||
Conditional formatting
Sorry for the wrong post…
-------------------- (Ms-Exl-Learner) -------------------- "Ms-Exl-Learner" wrote: Just copy and paste the below formula in any of the cell ="store.murpheythejeweler.com/store/p/"&7062+ROW(A1)&"-Tungsten-Flat-8mm-Polished-Band.aspx" Now place the cursor on the pasted cell and drag it for the remaining cells. Or Copy that cell and paste it for the remaining cells. If this post helps, Click Yes! -------------------- (Ms-Exl-Learner) -------------------- "Vinit" wrote: Hi, I need help I want to do the following thing in excel If i have to make condition for the selected cell that if any perticular cell is equal to something the selected cell should have some color, please let me know how i can do this? Thanks Vinit |
#4
|
|||
|
|||
Conditional formatting
Yes, you were right in the subject line. The facility you want is
"conditional formatting", so that is what you should type into Excel help. If there is something specific in there that you don't understand, come back to us with more details of what you don't understand. -- David Biddulph "Vinit" wrote in message ... Hi, I need help I want to do the following thing in excel If i have to make condition for the selected cell that if any perticular cell is equal to something the selected cell should have some color, please let me know how i can do this? Thanks Vinit |
#5
|
|||
|
|||
Conditional formatting
1. Select the cell (say A1). Please note that the cell reference A1 mentioned
in the formula is the active cell in the selection. Active cell will have a white background even after selection 2. From menu FormatConditional Formatting 3. For Condition1Select 'Formula Is' and enter the below formula =B1=5 4. Click Format ButtonPattern and select your color (say Red) 5. Hit OK PS: If you are using XL2007 Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a formula to determine which cells to format. Enter the formula in the box below. If this post helps click Yes --------------- Jacob Skaria "Vinit" wrote: Hi, I need help I want to do the following thing in excel If i have to make condition for the selected cell that if any perticular cell is equal to something the selected cell should have some color, please let me know how i can do this? Thanks Vinit |
#6
|
|||
|
|||
Conditional formatting
If i have to make condition for the selected cell that if any perticular
cell is equal to something the selected cell should have some color, Using the 'formula is' option to refer the other cell within the formula is the key.. like =B1=criteria will conditional format the selected cell based on cell B1 If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: 1. Select the cell (say A1). Please note that the cell reference A1 mentioned in the formula is the active cell in the selection. Active cell will have a white background even after selection 2. From menu FormatConditional Formatting 3. For Condition1Select 'Formula Is' and enter the below formula =B1=5 4. Click Format ButtonPattern and select your color (say Red) 5. Hit OK PS: If you are using XL2007 Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a formula to determine which cells to format. Enter the formula in the box below. If this post helps click Yes --------------- Jacob Skaria "Vinit" wrote: Hi, I need help I want to do the following thing in excel If i have to make condition for the selected cell that if any perticular cell is equal to something the selected cell should have some color, please let me know how i can do this? Thanks Vinit |
Thread Tools | |
Display Modes | |
|
|