conditional formatting help

[bam12]

i have the following formula for a conditional format. it is one of three for the cell

=if(and(h148<=today()-2),(I148=""),false)

i want to check b148 to see if it isequal to N/A, if so not to do formula

Is this possible?

Thanks in advance for any help

 

[cpg84]

From the code you entered, try doing =if(and(h148<=today()-2,I148=""),false)

Not exactly sure what you are after though

 

[bam12]

N/A

I will actually put the N/A in the cell if needed

if b148 has n/a i dont want to do the conditional formatting mentioned above

 

[cpg84]

Well, from my understanding of conditional formatting, if you have put in Conditional Formatting for true, itll format how you specify, same with false, if specified. If you have an N/A result and you don't want it to do the conditional formatting, it should stay as the default setting. So....just leave it and see what happens.

 

[bam12]

i have to check the content of b148 for N/A
, and right now i am not doing that

 

[bam12]

bump

 

[Scott Huish]

You really shouldn't need the IF, why do you have false?

What are the conditions you want it to apply the format for exactly?

 

[bam12]

code

it was code i found in a book for if (and formula

What i want to do is check b148 for anything, I was using n/a, which might be the wrong thing to use

so lets say that b148 has an x in it i dont want to do the conditional formatting, but if no x to do the conditional formatting

 

[Scott Huish]

If this is TRUE:
and(h148<=today()-2,I148="")

Do you want to format or not?

 

[Peter_SSs]

Since TODAY() is a "volatile" function and can slow your sheet down considerably if used a lot, I suggest putting =TODAY() in a vacant cell, say Z1, anf then see if this is what you want in the Conditional Formatting formula:
=AND(B148="",H148<=$Z$1-2,I148="")