Conditional formating problem. Please help.
 

I am having a problem with conditional formating. I have a bunch of cells
that I am appling conditional formating to but the formatting is not working
as it should.
Condition 1: Cell Value less than or equal to 0.3*$C4 fill:=Red
Condition 2: Cell Value greater than 0.3*$C4 and less than or equal to
0.8*$C4 fill:=Yellow
Condition 3: Cell Value greater than 0.8*$C4
fill:=Green

All the cells that I applied these conditions to are RED. And I can't figure
out what it is that I did, or am doing, wrong.
Any help will be greatly appreciated. Thanks

Conditional formating problem. Please help.
 

Are your cells in the same row and/or different columns?

You are using absolute reference ($C4) so all cells test against the value
in col C in that row and getting the same result...

Use C4 instead of $C4 (or whatever checks against the right cells)

"Ayo" wrote:

I am having a problem with conditional formating. I have a bunch of cells
that I am appling conditional formating to but the formatting is not working
as it should.
Condition 1: Cell Value less than or equal to 0.3*$C4 fill:=Red
Condition 2: Cell Value greater than 0.3*$C4 and less than or equal to
0.8*$C4 fill:=Yellow
Condition 3: Cell Value greater than 0.8*$C4
fill:=Green

All the cells that I applied these conditions to are RED. And I can't figure
out what it is that I did, or am doing, wrong.
Any help will be greatly appreciated. Thanks

Conditional formating problem. Please help.
 

They are all on the same row and they are testing against a single cell, C4.
All the cells have different values

"Sheeloo" wrote:

Are your cells in the same row and/or different columns?

You are using absolute reference ($C4) so all cells test against the value
in col C in that row and getting the same result...

Use C4 instead of $C4 (or whatever checks against the right cells)

"Ayo" wrote:

I am having a problem with conditional formating. I have a bunch of cells
that I am appling conditional formating to but the formatting is not working
as it should.
Condition 1: Cell Value less than or equal to 0.3*$C4 fill:=Red
Condition 2: Cell Value greater than 0.3*$C4 and less than or equal to
0.8*$C4 fill:=Yellow
Condition 3: Cell Value greater than 0.8*$C4
fill:=Green

All the cells that I applied these conditions to are RED. And I can't figure
out what it is that I did, or am doing, wrong.
Any help will be greatly appreciated. Thanks

Conditional formating problem. Please help.
 

To color A4, choose FORMULA IS instead of VALUE IS
and use the formula
=A4 < 0.3*$C4 for cond1
=AND(A4 0.3*$C4,A4 <= 0.8*$C4) for cond2
=A4 0.8*$C4 for condition 3

You can then pain the format over other cells you want...

"Ayo" wrote:

They are all on the same row and they are testing against a single cell, C4.
All the cells have different values

"Sheeloo" wrote:

Are your cells in the same row and/or different columns?

You are using absolute reference ($C4) so all cells test against the value
in col C in that row and getting the same result...

Use C4 instead of $C4 (or whatever checks against the right cells)

"Ayo" wrote:

I am having a problem with conditional formating. I have a bunch of cells
that I am appling conditional formating to but the formatting is not working
as it should.
Condition 1: Cell Value less than or equal to 0.3*$C4 fill:=Red
Condition 2: Cell Value greater than 0.3*$C4 and less than or equal to
0.8*$C4 fill:=Yellow
Condition 3: Cell Value greater than 0.8*$C4
fill:=Green

All the cells that I applied these conditions to are RED. And I can't figure
out what it is that I did, or am doing, wrong.
Any help will be greatly appreciated. Thanks

Conditional formating problem. Please help.
 

I have Excel 2007 and 2007 don't have those options

"Sheeloo" wrote:


To color A4, choose FORMULA IS instead of VALUE IS
and use the formula
=A4 < 0.3*$C4 for cond1
=AND(A4 0.3*$C4,A4 <= 0.8*$C4) for cond2
=A4 0.8*$C4 for condition 3

You can then pain the format over other cells you want...

"Ayo" wrote:

They are all on the same row and they are testing against a single cell, C4.
All the cells have different values

"Sheeloo" wrote:

Are your cells in the same row and/or different columns?

You are using absolute reference ($C4) so all cells test against the value
in col C in that row and getting the same result...

Use C4 instead of $C4 (or whatever checks against the right cells)

"Ayo" wrote:

I am having a problem with conditional formating. I have a bunch of cells
that I am appling conditional formating to but the formatting is not working
as it should.
Condition 1: Cell Value less than or equal to 0.3*$C4 fill:=Red
Condition 2: Cell Value greater than 0.3*$C4 and less than or equal to
0.8*$C4 fill:=Yellow
Condition 3: Cell Value greater than 0.8*$C4
fill:=Green

All the cells that I applied these conditions to are RED. And I can't figure
out what it is that I did, or am doing, wrong.
Any help will be greatly appreciated. Thanks

Conditional formating problem. Please help.
 

It does...
Click on Conditonal Formatting on HOME tab
Choose New Rule or (Manage Rule if you already have one)
Choose 'Use a formula to ....'

See attached file
http://wikisend.com/download/685184/Conditional Formatting.xlsx

"Ayo" wrote:

I have Excel 2007 and 2007 don't have those options

"Sheeloo" wrote:


To color A4, choose FORMULA IS instead of VALUE IS
and use the formula
=A4 < 0.3*$C4 for cond1
=AND(A4 0.3*$C4,A4 <= 0.8*$C4) for cond2
=A4 0.8*$C4 for condition 3

You can then pain the format over other cells you want...

"Ayo" wrote:

They are all on the same row and they are testing against a single cell, C4.
All the cells have different values

"Sheeloo" wrote:

Are your cells in the same row and/or different columns?

You are using absolute reference ($C4) so all cells test against the value
in col C in that row and getting the same result...

Use C4 instead of $C4 (or whatever checks against the right cells)

"Ayo" wrote:

I am having a problem with conditional formating. I have a bunch of cells
that I am appling conditional formating to but the formatting is not working
as it should.
Condition 1: Cell Value less than or equal to 0.3*$C4 fill:=Red
Condition 2: Cell Value greater than 0.3*$C4 and less than or equal to
0.8*$C4 fill:=Yellow
Condition 3: Cell Value greater than 0.8*$C4
fill:=Green

All the cells that I applied these conditions to are RED. And I can't figure
out what it is that I did, or am doing, wrong.
Any help will be greatly appreciated. Thanks

Conditional formating problem. Please help.
 

Thanks Sheeloo. I think that was it.

"Sheeloo" wrote:

It does...
Click on Conditonal Formatting on HOME tab
Choose New Rule or (Manage Rule if you already have one)
Choose 'Use a formula to ....'

See attached file
http://wikisend.com/download/685184/Conditional Formatting.xlsx

"Ayo" wrote:

I have Excel 2007 and 2007 don't have those options

"Sheeloo" wrote:


To color A4, choose FORMULA IS instead of VALUE IS
and use the formula
=A4 < 0.3*$C4 for cond1
=AND(A4 0.3*$C4,A4 <= 0.8*$C4) for cond2
=A4 0.8*$C4 for condition 3

You can then pain the format over other cells you want...

"Ayo" wrote:

They are all on the same row and they are testing against a single cell, C4.
All the cells have different values

"Sheeloo" wrote:

Are your cells in the same row and/or different columns?

You are using absolute reference ($C4) so all cells test against the value
in col C in that row and getting the same result...

Use C4 instead of $C4 (or whatever checks against the right cells)

"Ayo" wrote:

I am having a problem with conditional formating. I have a bunch of cells
that I am appling conditional formating to but the formatting is not working
as it should.
Condition 1: Cell Value less than or equal to 0.3*$C4 fill:=Red
Condition 2: Cell Value greater than 0.3*$C4 and less than or equal to
0.8*$C4 fill:=Yellow
Condition 3: Cell Value greater than 0.8*$C4
fill:=Green

All the cells that I applied these conditions to are RED. And I can't figure
out what it is that I did, or am doing, wrong.
Any help will be greatly appreciated. Thanks

Conditional formating problem. Please help.
 

There is a problem. The fill colors are all over the place. I have 30% to 80%
showing up as greeen instead of yellow and <30% showing up as Green instead
of Red. Do you have an idea was is going on?

"Sheeloo" wrote:

It does...
Click on Conditonal Formatting on HOME tab
Choose New Rule or (Manage Rule if you already have one)
Choose 'Use a formula to ....'

See attached file
http://wikisend.com/download/685184/Conditional Formatting.xlsx

"Ayo" wrote:

I have Excel 2007 and 2007 don't have those options

"Sheeloo" wrote:


To color A4, choose FORMULA IS instead of VALUE IS
and use the formula
=A4 < 0.3*$C4 for cond1
=AND(A4 0.3*$C4,A4 <= 0.8*$C4) for cond2
=A4 0.8*$C4 for condition 3

You can then pain the format over other cells you want...

"Ayo" wrote:

They are all on the same row and they are testing against a single cell, C4.
All the cells have different values

"Sheeloo" wrote:

Are your cells in the same row and/or different columns?

You are using absolute reference ($C4) so all cells test against the value
in col C in that row and getting the same result...

Use C4 instead of $C4 (or whatever checks against the right cells)

"Ayo" wrote:

I am having a problem with conditional formating. I have a bunch of cells
that I am appling conditional formating to but the formatting is not working
as it should.
Condition 1: Cell Value less than or equal to 0.3*$C4 fill:=Red
Condition 2: Cell Value greater than 0.3*$C4 and less than or equal to
0.8*$C4 fill:=Yellow
Condition 3: Cell Value greater than 0.8*$C4
fill:=Green

All the cells that I applied these conditions to are RED. And I can't figure
out what it is that I did, or am doing, wrong.
Any help will be greatly appreciated. Thanks