conditional formatting & AND function

[david zerykier]

i've been reading up on this for a few days, and cannot figure out how to write a simple line of code.

goal:
when there is no date entry to the right of a cell AND no entries in the row below the cell AND the date in the cell is 3 or more days ago, turn light blue.
when there is no date entry to the right of a cell AND no entries in the row below the cell AND the date in the cell is 7 or more days ago, turn DARK blue.

using cell G2 as a starting point, i keep failing in CF with syntaxx like:

=AND(H2:Z2="",A3:Z3="",TODAY()-G2>=3)

and then i figured i'd make a new rule and apply the '7' with different formatting.

but i can't decode the failure of that line^. and i've been using the 'blank' where i'd ideally use 'no date' because i'd like to incorporate other text, i just don't know if that's actually a thing that is possible.

i feel like i'm close, but,

frustrated....

help?

[etaf]

you need to create two rules

=AND(H2="",G3="",G2<=TODAY()-3,G2<>"")
=AND(H2="",G3="",G2<=TODAY()-7,G2<>"")

what range do you want to apply to and what cells would that be testing - i ask as that will depend on if there needs to be a $ in the formula

can you attach a sample sheet with examples of what you need

for 2007 or 2010 excel version
Conditional Formatting

Highlight applicable range >>
select the range you want to apply to, Note this may be required to add $ to formula

Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:

=AND(H2="",G3="",G2<=TODAY()-3,G2<>"")

Format… [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK

repeat for next for frmula

[Kaper]

If there are texts but no numbers then no dates (which are in fact numbers in Excel) condition could look like:

Please Login or Register  to view this content.

[bebo021999]

Maybe:

Please Login or Register  to view this content.

[david zerykier]

i'm sorry - i got that close, but not quite right.

applying the rule to all of col G, maybe 500 entries long, but using cell G2 as the example: (because G1 is the heading, and the formula is not applied)

when there is no date entry anywhere to the right of a cell AND no entries in the entire row below the cell AND the date in the cell is 3 or more days ago, turn cell G2 light blue.
when there is no date entry anywhere to the right of a cell AND no entries in the entire row below the cell AND the date in the cell is 7 or more days ago, turn cell G2 DARK blue.

thank you all for jumping on this.

[bebo021999]

What do you mean with "no date entry"? is it possible with text or number?
Anyway, can you upload an example with errors from my formula?