Creating a formula to highlight a row of cells

  • Thread starter Thread starter Randy A.
  • Start date Start date
R

Randy A.

I am creating a worksheet for use in our sales department. What I want to do
is create a formula that will highlight a row of cells when specific data is
entered into one cell within that row.

Example: If "D" is entered into the specific cell, it will highlight the
row of cells in "yellow". If "X" is entered into the specific cell, it will
highlight the row of cells in "pink".

Is there a formula that will allow me to do this? Any assistance would be
greatly appreciated.

Thanks
 
You didn't say, so I'll assume specific cell is in colum B

Select entire row. Go to Format-Condition Format.
Set first box to "formula is"
Input
=$B2="D"
Click format, pattern, select yellow. Then add another condition.
formula is:
=$B2="X"
Select pink pattern. Copy formatting to as many rows as desired.
 
Luke M...

Thanks for the information, the only problem I'm having is I can't find the
"Format-Condition Format" area you directed me too. After I've highlighted
the row, where do I go to get to the Format-Condition Format area so that I
can input the formula you gave me?

I'm usinig Excel 2007.

Thanks

Randyt
 
Sorry, for XL2007:
Go to Home, Conditional Formatting, New Rule
Choose 'Use a formula'
In the spot where this formula is true, input the first formula formula
Add a new rule
input the second formula.

I'm afraid I don't use 2007, so I'm having to go from second-hand
information here. Hopefully this gets you at least close to where you need to
go.
 
Back
Top