Cond.Format

[Bertronix]

Hi,
I have an F1 cell headed as DUE DATE that automatically turns red after tha date typed in A1. The F1 cell is formatted =F1=today(). I'm trying to get the G1 cell to turn the F1 cell to green or whatever when I type an X in G1 which is my PAID header. I tried a couple formulas that didn't work. any ideas? Thanks,Bert.

[PaddyD]

Betronix,

Your post isn't totally clear, but I've made a few assumptions. (e.g. that you meant =a1=today() when you wrote 'The F1 cell is formatted =F1=today()'.

How about 2 conditions on the format:

The first checks whether it's today & whether there's an x in G1:

=(AND(A1=TODAY(),NOT(G1="X")))

The other whether there's an X in G1:

=G1="X"

Some variation on this theme should do it...

Paddy


[ This Message was edited by: PaddyD on 2002-05-20 15:26 ]

[Bertronix]

The previous post was supposed to read-I have an F1 cell headed as DUE DATE that automatically turns red 45 days after the date typed in A1. I need the G1 cell (PAID)to turn F1 cell to green when I type an X in G1. Sorry for the misprint and confusion.Thanks, Bert.

[Bertronix]

PaddyD,
I tried =G1="x" and also =countif(gcell,"=x") neither one is working. I already have conditional format in F1. Bert.

[Yogi Anand]

On 2002-05-20 15:30, Bertronix wrote:
PaddyD,
I tried =G1="x" and also =countif(gcell,"=x") neither one is working. I already have conditional format in F1. Bert.

Hi Bentronix:
Did you not post this or some thing very similar about an hour ago?

[PaddyD]

Bert,

Might this be the problem - you need to make sure you exclude the X condition in the first format. Conditional format evalates conditions to true / false, and will always apply the format of the first true condition, whether the value of the rest. so excluding G1="X" gets the first condition to evaluate false if there's an X in G1, letting the second format have a go...

Paddy

[Bertronix]

Reply to paddyD- I'm so new to Excel I don't have a clue what your last reply meant-sorry. In response to Yogi- yes I did post something similar to this but started a new thread because the old one started getting lost and no reply. Sorry if that's a no-no! beRtronix.

[sen_edp]

Hello

Try conditional formatting on the date cell
i.e e23 and the x cell is g23

condition 1 , formula is=($E$23=TODAY())*($G$23="X") with green background

condition 2 , formula is=($E$23=TODAY())*($G$23=" ") with red background

hope that helps

_________________
Best Regards,
Andreas
using Excel 2000 - Windows 2000 prof.

[ This Message was edited by: sen_edp on 2002-05-20 15:47 ]

[PaddyD]

Bert,
If you're using conditional formatting, you're already getting more out of excel than many people who've been sent on expensive courses...& if you're a member of this board, you're only going to get better!

How about you post the formats you've already got & we can take it from there?

Paddy

[Yogi Anand]

On 2002-05-20 15:42, Bertronix wrote:
Reply to paddyD- I'm so new to Excel I don't have a clue what your last reply meant-sorry. In response to Yogi- yes I did post something similar to this but started a new thread because the old one started getting lost and no reply. Sorry if that's a no-no! beRtronix.

Hi Bertronix:
In reference to your statement for Paddy, just hang on and stick with it. Using Excel is like learning another language, the more you use it, and the more interest you take in it, the better you will become at it.
In regard to my question to you for having posted this earlier, please post it once so that you can get a meaningful response, and then if you want to follow that up for clarification, there is a reference point to work with, otherwise it is a new ball game all over. I hope you understand that posting it once is benecificial both for the person who is asking the question and also for the people who respond.

Regards!