conditional formatting help

bam12

Well-known Member
Joined
Dec 6, 2004
Messages
984
i have the following formula for a conditional format. it is one of three for the cell

Code:
=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
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.
From the code you entered, try doing =if(and(h148<=today()-2,I148=""),false)

Not exactly sure what you are after though
 
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0
i have to check the content of b148 for N/A
, and right now i am not doing that
 
Upvote 0
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?
 
Upvote 0
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
 
Upvote 0
If this is TRUE:
and(h148<=today()-2,I148="")

Do you want to format or not?
 
Upvote 0
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="")
 
Upvote 0

Forum statistics

Threads
1,213,533
Messages
6,114,179
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top