Excel 2007 Conditional Formatting Problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Glenn - 18 Apr 2008 19:03 GMT

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 D4:D7 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

Reply to this Message

Jim Rech - 18 Apr 2008 20:54 GMT

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.

Signature

Jim

| Hi,
| I've got a little problem.
[quoted text clipped - 18 lines]
| Regards,
| Glenn

Reply to this Message

Glenn - 19 Apr 2008 14:34 GMT

yes please,
Thanks

> I selected the range C4:F7, with C4 the active cell, and create this formula
> rule:
[quoted text clipped - 32 lines]
> | Regards,
> | Glenn

Reply to this Message