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

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

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

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

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

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