Conditional formatting

  • Thread starter Thread starter Vinit
  • Start date Start date
V

Vinit

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
 
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!
 
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.
 
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 Format>Conditional Formatting>
3. For Condition1>Select 'Formula Is' and enter the below formula
=B1=5
4. Click Format Button>Pattern and select your color (say Red)
5. Hit OK

PS: If you are using XL2007 Goto Home tab>Styles>Conditional
Formatting>Manage rules>New rule>Use a formula to determine which cells to
format. Enter the formula in the box below.

If this post helps click Yes
 
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,
Click to expand...

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
 
Back
Top