Search results

Narayan, good to here from you If the first two rules do not apply (that being A1 does not have "Angle" or "Surface" in it) then the last rule would apply... does that help? Dennis

Thank-you Hui… I suspected that would be the case. I can’t use the same logic in both cells however there is an alternative solution that would work but it’s beyond my skill level, maybe you can help or maybe I’m trying to do something that’s not possible, I’d need a CF formula in A5 that can do...

Is it possible to put a formula in a conditional format that causes a match of the format in a different cell? Let’s say we can enter a number 1 or 2 in cell A1… the conditional formatting in A1 causes white fill for 1 and red fill for 2. The conditional format formula in B2 would cause a...

Narayan... that's what I thought, I did find another way of getting the same results... thanks Dennis

Thank you Khalid NGO

In the validation dialog box… is it possible to enter a custom formula that ignites an alert if the cell has a specific fill pattern? The formula… an alert would appear if any entry is attempted in a cell that has the fill pattern. If a specific fill pattern can not be specified then would it...

SM... pretty cool, it works perfectly... maybe someday I'll be that smart... thank you so much, Dennis

Hi there Prasad DN... thank you for the formula… "Angle" & "Surface Finish" never appear together in F42. I'm a little embarrassed to say this but we are in the process of upgrading but are currently still using Excel 2003. Your formula returns a #NAME?, would it be possible to use ISERROR, I...

I’m using the formula below that works well; I’ve been unsuccessfully trying to slightly alter it. I’m looking for the whole formula which resides in J42 to do the following. If F42 has the text “Angle” then G42 If F42 has the text “Surface Finish” then G42/40 If F42 has anything other then...

Nebu... thank you, I appreciate the help

Narayan... thank you, works great, I greatly appreciate your help

PaulF... that's impressive, problem solved, my headache is finally going away... thank-you so much

Narayan... if I remove the equal sign "=" I do not get the error but it does not change the formatting

Wudixin96... it's not working here

Narayan... returns the message "You may not use union, intersection or array constants for conditional formatting criteria"

Paul... file is upload, looks like the SEARCH function might be the problem

Hi Paul and thanks for the quick reponse... putting the formula in any cell returns a message that says the formula contains an error.

This has now given me a headache, can someone please tell me what I'm doing wrong here. In H42 I have a conditional format with this formula in it... OR(ISNUMBER(SEARCH(F42="Profile",F42="Angle...

SM... after further review I think I'll use it as is, thanks for the help, it's greatly appreciated

SM... works great except for one thing that I neglected to mention, the text "Finish" and "Angle" are just two words of a larger string of text, so the formula needs to search through the entire string to find them.

This doesn't look that difficult to me, but I just haven't been able to make anything work, any help will be greatly appreciated. Looking for a formula to be placed in J2 F2 may or may not have one of two texts "Finish" or " Angle" If F2 has either one of these texts then J2 should equal G2 If...

Thanks Luke M... I'll play around with your suggestions

Is it possible to have Excel display a number exactly the way it is typed in a cell, for example. Enter 1 and Excel displays 1 this is good Enter 1.0 and Excel displays 1 we need it to display 1.0 Enter 1.00 and Excel displays 1 we need it to display 1.00 Enter 1.000 and Excel displays 1 we...

SM... once again you have succeeded to amaze, as usual your macro works perfectly, thank you so much

Is it possible to create a macro to delete an entire row that is one row below a repeating text string? A1 has the text [PartSetup] A2 starts with the text name= then followed by a combination of varying alpha numeric characters, here’s what it might look like. A1 [PartSetup] A2...