Excel Add Days

Bertronix · May 20th, 2002, 02:55 PM

Hi,
Thanks to Dreamboat,sykes, and kinkyparamour I got my "F cell" to add 45 days to mt "A cell" "AND" got my "F cell" to turn red after the 45 days. Last but not least, I'm heading my "G cell" as PAID. Can I get the red "F cell" to turn green or at least clear from red When I type an X in the "G cell" to indicate it's been paid?Thanks again, Bert.

Brian from Maui · May 20th, 2002, 03:00 PM

Try

=countif(gcell,"=x")
with conditional formatting in the F cell

Yogi Anand · May 20th, 2002, 03:03 PM

In cell F1, apply Conditional formatting with

Formula is =G1="X" ... then FORMAT|PATTERNS| color green

Brian from Maui · May 20th, 2002, 03:11 PM

Gotta stop using countif

Yogi Anand · May 20th, 2002, 03:16 PM

Hi Brian: Aloha!
Did you try using the simple =G1="X"?

Bertronix · May 20th, 2002, 03:18 PM

Do I add this to the existing condition in F1 or as a second condition? It's not working how I'm doing it. Thanks, Bert,

Yogi Anand · May 20th, 2002, 06:37 PM

Hi Bert:
Since you did start another thread on this, I believe this thread ought to be closed now.

kinkyparamour · May 20th, 2002, 08:35 PM

Bert,
If you want to change the cell green or what ever after the invoice is paid you need to change the condition we setup yesterday. Take the condition you have now and make it condition number 2. Now set a new condition as number 1. Again we are going to highlight the cell you want to change, I think it was j2. If this is true and Paid is in k2 install the following as your condition.
=$k$2="paid"
Now choose a new color. This will allow your cell to turn red when you reach the 45 day point and green or whatever when the invoice is paid.

In the future we need to keep the questions in the same thread, this will make it easier for people to follow and to answer because they will know what was done before....

Denny

May 20th, 2002, 03:03 PM	#3
Yogi Anand MrExcel MVP Join Date: Mar 2002 Location: Michigan USA Posts: 11,452	In cell F1, apply Conditional formatting with Formula is =G1="X" ... then FORMAT\|PATTERNS\| color green __________________ Regards! Yogi Anand, D.Eng, P.E. Energy Efficient Building Network LLC www.energyefficientbuild.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 20th, 2002, 02:55 PM	#1
Bertronix New Member Join Date: May 2002 Posts: 40	Hi, Thanks to Dreamboat,sykes, and kinkyparamour I got my "F cell" to add 45 days to mt "A cell" "AND" got my "F cell" to turn red after the 45 days. Last but not least, I'm heading my "G cell" as PAID. Can I get the red "F cell" to turn green or at least clear from red When I type an X in the "G cell" to indicate it's been paid?Thanks again, Bert.

May 20th, 2002, 03:00 PM	#2
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	Try =countif(gcell,"=x") with conditional formatting in the F cell

May 20th, 2002, 03:11 PM	#4
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	Gotta stop using countif

May 20th, 2002, 03:16 PM	#5
Yogi Anand MrExcel MVP Join Date: Mar 2002 Location: Michigan USA Posts: 11,452	Hi Brian: Aloha! Did you try using the simple =G1="X"?

May 20th, 2002, 03:18 PM	#6
Bertronix New Member Join Date: May 2002 Posts: 40	Do I add this to the existing condition in F1 or as a second condition? It's not working how I'm doing it. Thanks, Bert,

May 20th, 2002, 06:37 PM	#7
Yogi Anand MrExcel MVP Join Date: Mar 2002 Location: Michigan USA Posts: 11,452	Hi Bert: Since you did start another thread on this, I believe this thread ought to be closed now.

May 20th, 2002, 08:35 PM	#8
kinkyparamour Board Regular Join Date: Feb 2002 Location: Florida Posts: 82	Bert, If you want to change the cell green or what ever after the invoice is paid you need to change the condition we setup yesterday. Take the condition you have now and make it condition number 2. Now set a new condition as number 1. Again we are going to highlight the cell you want to change, I think it was j2. If this is true and Paid is in k2 install the following as your condition. =$k$2="paid" Now choose a new color. This will allow your cell to turn red when you reach the 45 day point and green or whatever when the invoice is paid. In the future we need to keep the questions in the same thread, this will make it easier for people to follow and to answer because they will know what was done before.... Denny