Excel formula needed

[captainron]

how do i write this formula:
If any cell from B3:G17 = B1 then i want that cell that equals B1 to change to a selected colour, lets say RED?

 

[T. Valko]

how do i write this formula:
If any cell from B3:G17 = B1 then i want that cell that equals B1 to change to a selected colour, lets say RED?

What version of Excel are you using?

 

[jc.021286]

You are looking for conditional formatting.

Select your B3:G17 Range,

Go to Conditional Formating > Equal to
or custom Formual
Formula =$B$1

Pick a red format of your liking,
Ok and Apply it to this range.

jc

 

[captainron]

excel 2003

 

[captainron]

Ok thanks.

Just one more question, say i have 6 cells, and if any number that is in the range of cells B3:G17 is equal to one of the six cells, then it changes colour.

 

[T. Valko]

excel 2003

Ok, try this...

Select the *entire* range B3:G17 starting from cell B3. Cell B3 will be the
active cell. The active cell is the one cell in the selected range that is not shaded. The formula will be relative to the active cell.

• Goto the menu Format>Conditional Formatting
• Select the Formula Is option
• Enter this formula in the box on the right:
• =AND(B3<>"",B3=$B$1)
• Click the Format button
• Select the desired style(s)
• OK out

 

[T. Valko]

Ok thanks.

Just one more question, say i have 6 cells, and if any number that is in the range of cells B3:G17 is equal to one of the six cells, then it changes colour.

Sounds like you want to check your lottery numbers!

What is the range of 6 cells that hold the numbers?

 

[captainron]

that formula works when i put in one number in cell B1, but I want to be able to put numbers in Cells C1,D1,E1,F1,G1 and highlight red the numbers in B3:G17

right now nothing happens when i enter numbers in those cells

 

[T. Valko]

that formula works when i put in one number in cell B1, but I want to be able to put numbers in Cells C1,D1,E1,F1,G1 and highlight red the numbers in B3:G17

right now nothing happens when i enter numbers in those cells

Try this...

Conditional Formatting
Formula Is: =OR(B3=$B$1:$G$1)