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

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

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

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

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

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

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

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