Excel 2007 Conditional Formatting Problem

[Glenn]

Hi,
I've got a little problem.
I'm busy with a spreadsheat where i can see if someone has been paid
on a sertain date.
I've made a litte example-spreadsheat:
http://www.savefile.com/files/1512005

The Problem:
I want the numbers in the range C4:F7 to be colored green if it is
paid and red if not and when there is a zero in the cell that there is
no color..
in the range 17F:17I you can see if there has been paid on that day.
I can put a conditional formatting in the range C4:C7 like:
=0, no filling (stop when true)
=17F="yes", green filling
-17F="no", red filling
And in the range D47 the same with the cell: 17G
This is doable with 4 columns but not with 30...
So is there a friendlier way?
I hope so..
Regards,
Glenn

 

[Jim Rech]

I selected the range C4:F7, with C4 the active cell, and create this formula
rule:

=AND(C4>0,F$17="yes")

and set this to produce a green fill.

Then a second rule for red fill changing the "yes" to "no"

Note the "$" before the 17 of F17 is key.

Let me know if you want me to email my example to you.

--
Jim
| Hi,
| I've got a little problem.
| I'm busy with a spreadsheat where i can see if someone has been paid
| on a sertain date.
| I've made a litte example-spreadsheat:
| http://www.savefile.com/files/1512005
|
| The Problem:
| I want the numbers in the range C4:F7 to be colored green if it is
| paid and red if not and when there is a zero in the cell that there is
| no color..
| in the range 17F:17I you can see if there has been paid on that day.
| I can put a conditional formatting in the range C4:C7 like:
| =0, no filling (stop when true)
| =17F="yes", green filling
| -17F="no", red filling
| And in the range D47 the same with the cell: 17G
| This is doable with 4 columns but not with 30...
| So is there a friendlier way?
| I hope so..
| Regards,
| Glenn

 

[Glenn]

yes please,
Thanks