Conditional formatting based on a value in a seperate cell
 

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?
--
Thank you and have a great day!

Sincerely,
Cassie

Conditional formatting based on a value in a seperate cell
 

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

"Cassie" wrote:

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?
--
Thank you and have a great day!

Sincerely,
Cassie

Conditional formatting based on a value in a seperate cell
 

I think you need FormulaIs. Look at the examples he
http://www.contextures.com/xlCondFormat02.html

HTH,
Ryan---
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"ker_01" wrote:

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

"Cassie" wrote:

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?
--
Thank you and have a great day!

Sincerely,
Cassie