Coloring Rows Automatically

  • Thread starter Thread starter Scott V.
  • Start date Start date
S

Scott V.

Hello,
I would like to set a parameter so that when a certain
cell reaches a given value the entire row will turn a
specific color or be stricken through. Example is below...

Completed...... Strikethrough
In Progress...... Green
Not Started...... Blue
Started........ Yellow

I have tried to use the conditional formatting and that
works well but is limited by only the current cell, vs the
entire row and this causes a reading issue. Is there an
answer for this?

Any and all help will be greatly appreciated.

Thanks,

Scott
 
One way:

Assume the "certain cell" is in column A, starting in Row 2. Select
the entire rows (or just the range) in your data range. Use
Conditional Formatting (with a cell in row 2 active):

CF1: Formula is =$A2="Completed"
FMT1: Strikethrough

CF2: Formula is =$A2="In Progress"
FMT2: Green

CF3: Formula is =$A2="Started"
FMT3 Yellow
 
Scott

I would set the format of each cell in the row to blue, and then go to
Format, Conditional Formatting..., and use the "formula is" option in each
cell you want changed. You can do it for one cell, and then copy it to the
others (provided the $ is in the right place!)

eg your first condition might be entered as $B5=1 it will display as =$B5=1
your second $B5=2
=$B5=2
third $B5=3
=$B5=3

You then only have to arrange for the cells in column B to contain nothing,
1, 2, or 3. and the cells should format accordingly.

Alan
 
Conditional formatting works fine with the entire row if you apply
conditional formatting to the entire row.

Instead of using Cell Value is, you have to change the selection to Formula
is and then enter a formula that will make the proper determination. for
example if I am formatting Cell B2 and I want it dependent on the value in
M2

formula is =$M2>25

You select all the cells at once, assume A2 is the active Cell (construct
the formula to work with the active cell)

Formula is =$M2>25

will be properly applied to all the cells. The column is Fixed to look at
M, but the row is adjusted to the appropriate row relative to the
activecell.
 
Back
Top