Conditional formatting based on a value in a seperate cell

  • Thread starter Thread starter Cassie
  • Start date Start date
C

Cassie

Heeeeeeellllllp please!!

I am somewhat new to the excel world so i am constantly learning how to do
things but this is the first 1 i just cant figure out!

I have cells A, B, C, & D. D is conditional formatted where if the value is
greater than or equal to cell A, the font shall be orange. My dilemma is I
also need to get cells B & C to be change if the fomat for cell D changes?
How can I do this without manually formatting the font several times daily?
 
Hi Cassie-

It sounds like you are probably using the default "cell value is". I'll give
instructions for Excel2003, since you don't specify which version you are
using.

Instead of using "cell value is", use "formula is". Put in the formula you
are interested in. In this case, let's say that you are entering the
conditional formatting in cell D2. It would be something like =$D$2>=$A$2

That's fine for one row, but to be able to copy it to other rows, change it
to:
=$D2>=$A2
and then select your desired formatting options (shading, etc).

copy that one cell, then select your entire A:D target range and "paste
special"/"format"

The end result should be that each row will dynamically change based on that
row's A and D values.

HTH,
Keith
 
Back
Top