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