|
isformula?
isn't there a way to point at a cell and ask whether it is
a number vs a formula. I'd like to use conditional formatting and have formatting applied to any cell which is a number and NOT a formula. But ISNUMBER returns true if the RESULT is a number, not the input. So for ex: if a1 says =a2+a3 and b1 is 3, I'd like the result to be false fora1 and true for b1? Is this possible without VB? tia, Dave |
Does this help?
Hit <F5, and click on <Special. Then click on "Constants", then <OK. This selects all your non-formula cells. While they're all selected, you could color them if you wish. You could also go the "other " way, and select the formulas. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "dave" wrote in message ... isn't there a way to point at a cell and ask whether it is a number vs a formula. I'd like to use conditional formatting and have formatting applied to any cell which is a number and NOT a formula. But ISNUMBER returns true if the RESULT is a number, not the input. So for ex: if a1 says =a2+a3 and b1 is 3, I'd like the result to be false fora1 and true for b1? Is this possible without VB? tia, Dave |
I'd still like to find out how it can be done via
conditional formatting, but I'll use your method until I find out - thanks. -----Original Message----- Does this help? Hit <F5, and click on <Special. Then click on "Constants", then <OK. This selects all your non-formula cells. While they're all selected, you could color them if you wish. You could also go the "other " way, and select the formulas. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "dave" wrote in message ... isn't there a way to point at a cell and ask whether it is a number vs a formula. I'd like to use conditional formatting and have formatting applied to any cell which is a number and NOT a formula. But ISNUMBER returns true if the RESULT is a number, not the input. So for ex: if a1 says =a2+a3 and b1 is 3, I'd like the result to be false fora1 and true for b1? Is this possible without VB? tia, Dave . |
Dave,
Create a UDF and use that in the CF formula Function IsFormula(rng As Range) IsFormula = rng.HasFormula End Function -- HTH RP (remove nothere from the email address if mailing direct) "dave" wrote in message ... I'd still like to find out how it can be done via conditional formatting, but I'll use your method until I find out - thanks. -----Original Message----- Does this help? Hit <F5, and click on <Special. Then click on "Constants", then <OK. This selects all your non-formula cells. While they're all selected, you could color them if you wish. You could also go the "other " way, and select the formulas. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "dave" wrote in message ... isn't there a way to point at a cell and ask whether it is a number vs a formula. I'd like to use conditional formatting and have formatting applied to any cell which is a number and NOT a formula. But ISNUMBER returns true if the RESULT is a number, not the input. So for ex: if a1 says =a2+a3 and b1 is 3, I'd like the result to be false fora1 and true for b1? Is this possible without VB? tia, Dave . |
dave
Not without VBA. See Bob's answer for UDF. Gord Dibben Excel MVP On Sat, 26 Mar 2005 14:03:01 -0800, "dave" wrote: I'd still like to find out how it can be done via conditional formatting, but I'll use your method until I find out - thanks. -----Original Message----- Does this help? Hit <F5, and click on <Special. Then click on "Constants", then <OK. This selects all your non-formula cells. While they're all selected, you could color them if you wish. You could also go the "other " way, and select the formulas. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "dave" wrote in message ... isn't there a way to point at a cell and ask whether it is a number vs a formula. I'd like to use conditional formatting and have formatting applied to any cell which is a number and NOT a formula. But ISNUMBER returns true if the RESULT is a number, not the input. So for ex: if a1 says =a2+a3 and b1 is 3, I'd like the result to be false fora1 and true for b1? Is this possible without VB? tia, Dave . |
thanks! Isuppose a UDF is still pretty easy as opposed to
writing code every time -----Original Message----- Dave, Create a UDF and use that in the CF formula Function IsFormula(rng As Range) IsFormula = rng.HasFormula End Function -- HTH RP (remove nothere from the email address if mailing direct) "dave" wrote in message ... I'd still like to find out how it can be done via conditional formatting, but I'll use your method until I find out - thanks. -----Original Message----- Does this help? Hit <F5, and click on <Special. Then click on "Constants", then <OK. This selects all your non-formula cells. While they're all selected, you could color them if you wish. You could also go the "other " way, and select the formulas. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "dave" wrote in message ... isn't there a way to point at a cell and ask whether it is a number vs a formula. I'd like to use conditional formatting and have formatting applied to any cell which is a number and NOT a formula. But ISNUMBER returns true if the RESULT is a number, not the input. So for ex: if a1 says =a2+a3 and b1 is 3, I'd like the result to be false fora1 and true for b1? Is this possible without VB? tia, Dave . . |
I've added the code - and I'm trying to make the CF work.
I'm using cell value is equal to =Isformula=true, but it doesn't seem to work. what am I doing wrong? -----Original Message----- Dave, Create a UDF and use that in the CF formula Function IsFormula(rng As Range) IsFormula = rng.HasFormula End Function -- HTH RP (remove nothere from the email address if mailing direct) "dave" wrote in message ... I'd still like to find out how it can be done via conditional formatting, but I'll use your method until I find out - thanks. -----Original Message----- Does this help? Hit <F5, and click on <Special. Then click on "Constants", then <OK. This selects all your non-formula cells. While they're all selected, you could color them if you wish. You could also go the "other " way, and select the formulas. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "dave" wrote in message ... isn't there a way to point at a cell and ask whether it is a number vs a formula. I'd like to use conditional formatting and have formatting applied to any cell which is a number and NOT a formula. But ISNUMBER returns true if the RESULT is a number, not the input. So for ex: if a1 says =a2+a3 and b1 is 3, I'd like the result to be false fora1 and true for b1? Is this possible without VB? tia, Dave . . |
select the cells, assume A1 is the first, and in CF add a formula of
=IsFormula(A1) -- HTH RP (remove nothere from the email address if mailing direct) "dave" wrote in message ... I've added the code - and I'm trying to make the CF work. I'm using cell value is equal to =Isformula=true, but it doesn't seem to work. what am I doing wrong? -----Original Message----- Dave, Create a UDF and use that in the CF formula Function IsFormula(rng As Range) IsFormula = rng.HasFormula End Function -- HTH RP (remove nothere from the email address if mailing direct) "dave" wrote in message ... I'd still like to find out how it can be done via conditional formatting, but I'll use your method until I find out - thanks. -----Original Message----- Does this help? Hit <F5, and click on <Special. Then click on "Constants", then <OK. This selects all your non-formula cells. While they're all selected, you could color them if you wish. You could also go the "other " way, and select the formulas. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "dave" wrote in message ... isn't there a way to point at a cell and ask whether it is a number vs a formula. I'd like to use conditional formatting and have formatting applied to any cell which is a number and NOT a formula. But ISNUMBER returns true if the RESULT is a number, not the input. So for ex: if a1 says =a2+a3 and b1 is 3, I'd like the result to be false fora1 and true for b1? Is this possible without VB? tia, Dave . . |
|
thanks again
-----Original Message----- select the cells, assume A1 is the first, and in CF add a formula of =IsFormula(A1) -- HTH RP (remove nothere from the email address if mailing direct) "dave" wrote in message ... I've added the code - and I'm trying to make the CF work. I'm using cell value is equal to =Isformula=true, but it doesn't seem to work. what am I doing wrong? -----Original Message----- Dave, Create a UDF and use that in the CF formula Function IsFormula(rng As Range) IsFormula = rng.HasFormula End Function -- HTH RP (remove nothere from the email address if mailing direct) "dave" wrote in message ... I'd still like to find out how it can be done via conditional formatting, but I'll use your method until I find out - thanks. -----Original Message----- Does this help? Hit <F5, and click on <Special. Then click on "Constants", then <OK. This selects all your non-formula cells. While they're all selected, you could color them if you wish. You could also go the "other " way, and select the formulas. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "dave" wrote in message ... isn't there a way to point at a cell and ask whether it is a number vs a formula. I'd like to use conditional formatting and have formatting applied to any cell which is a number and NOT a formula. But ISNUMBER returns true if the RESULT is a number, not the input. So for ex: if a1 says =a2+a3 and b1 is 3, I'd like the result to be false fora1 and true for b1? Is this possible without VB? tia, Dave . . . |
Hi Dave.........
You seem somewhat tentative.........did you get this working for you application? Bob's UDF suggestion really does work fine once you put the code in a regular module and then use the "formula" in the CF "Formula is" window.........if you're still having trouble, send me your workbook at my HOME addy and I will install it for you.......... Vaya con Dios, Chuck, CABGx3 "dave" wrote in message ... thanks again -----Original Message----- select the cells, assume A1 is the first, and in CF add a formula of =IsFormula(A1) -- HTH RP (remove nothere from the email address if mailing direct) "dave" wrote in message ... I've added the code - and I'm trying to make the CF work. I'm using cell value is equal to =Isformula=true, but it doesn't seem to work. what am I doing wrong? -----Original Message----- Dave, Create a UDF and use that in the CF formula Function IsFormula(rng As Range) IsFormula = rng.HasFormula End Function -- HTH RP (remove nothere from the email address if mailing direct) "dave" wrote in message ... I'd still like to find out how it can be done via conditional formatting, but I'll use your method until I find out - thanks. -----Original Message----- Does this help? Hit <F5, and click on <Special. Then click on "Constants", then <OK. This selects all your non-formula cells. While they're all selected, you could color them if you wish. You could also go the "other " way, and select the formulas. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "dave" wrote in message ... isn't there a way to point at a cell and ask whether it is a number vs a formula. I'd like to use conditional formatting and have formatting applied to any cell which is a number and NOT a formula. But ISNUMBER returns true if the RESULT is a number, not the input. So for ex: if a1 says =a2+a3 and b1 is 3, I'd like the result to be false fora1 and true for b1? Is this possible without VB? tia, Dave . . . |
| All times are GMT +1. The time now is 09:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com