formulate if then conditions with text . date

September 27, 2011 at 10:46:10
Specs: Windows XP
Any help with excel if then with text and dates: IF cell G15, name, = cell H15, same name, AND cell I 15, date, is before cell J15, date, THEN return date in red. ??

See More: formulate if then conditions with text . date

Report •


#1
September 27, 2011 at 12:55:12
re: "...THEN return date in red"

Return what date?

And what do you mean by return it in red?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
September 27, 2011 at 15:07:04
I'm entering a date in Cell I15, and I want a trigger if the date conflicts, assuming the first condition is met.

Thanks for helping!


Report •

#3
September 27, 2011 at 17:14:49
Do us a favor...

Make believe that you are one of us and go back and read your original post.

Could you tell from what you wrote that you were entering a date in a specific cell and that you wanted it formatted a specific way upon entering it?

The clearer you are with the description of your issue, the higher the possibility of getting a good response.

Use this in Conditional Formatting:

=AND(G15=H15,I15<J15)

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question