Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cond Format if cell contains Values INSTEAD of a formula
I cannot figure this out no matter what I do
Every formula it try to apply addresses the RESULT of the formula (as it should) instead of the value. any solution much appreciated thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cond Format if cell contains Values INSTEAD of a formula
First enter this small UDF:
Function formulaa(r As Range) As Integer formulaa = 1 If r.HasFormula Then formulaa = 2 End If End Function The UDF tells you if a cell has a formula in it or just a value. For example if A1 contains 3 then =formulaa(A1) will display 1 If A1 contains =1+2 then formulaa(A1) will display a 2 To set the Conditional Format for Z100: Format Conditional Formatting... Formula is =formulaa(Z100)=2 and pick a distinctive format -- Gary''s Student - gsnu200739 "Finny388" wrote: I cannot figure this out no matter what I do Every formula it try to apply addresses the RESULT of the formula (as it should) instead of the value. any solution much appreciated thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cond Format if cell contains Values INSTEAD of a formula
On Aug 24, 1:40 pm, Finny388 wrote:
I cannot figure this out no matter what I do Every formula it try to apply addresses the RESULT of the formula (as it should) instead of the value. any solution much appreciated thanks Any help would be great. I need a way to highlight a cell if a text value has replaced the formula - to know alert this value is not the formula's doing but the users. Because either a value or the result of a formula is valid, it is just very important to make them visually distinct. thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cond Format if cell contains Values INSTEAD of a formula
On Aug 25, 11:24 am, Finny388 wrote:
On Aug 24, 1:40 pm, Finny388 wrote: I cannot figure this out no matter what I do Every formula it try to apply addresses the RESULT of the formula (as it should) instead of the value. any solution much appreciated thanks Any help would be great. I need a way to highlight a cell if a text value has replaced the formula - to know alert this value is not the formula's doing but the users. Because either a value or the result of a formula is valid, it is just very important to make them visually distinct. thanks ^ |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cond Format if cell contains Values INSTEAD of a formula
On Aug 27, 9:19 am, Finny388 wrote:
On Aug 25, 11:24 am, Finny388 wrote: On Aug 24, 1:40 pm, Finny388 wrote: I cannot figure this out no matter what I do Every formula it try to apply addresses the RESULT of the formula (as it should) instead of the value. any solution much appreciated thanks Any help would be great. I need a way to highlight a cell if a text value has replaced the formula - to know alert this value is not the formula's doing but the users. Because either a value or the result of a formula is valid, it is just very important to make them visually distinct. thanks ^ Impossible? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cond Format if cell contains Values INSTEAD of a formula
On Aug 27, 12:29 pm, Finny388 wrote:
On Aug 27, 9:19 am, Finny388 wrote: On Aug 25, 11:24 am, Finny388 wrote: On Aug 24, 1:40 pm, Finny388 wrote: I cannot figure this out no matter what I do Every formula it try to apply addresses the RESULT of the formula (as it should) instead of the value. any solution much appreciated thanks Any help would be great. I need a way to highlight a cell if a text value has replaced the formula - to know alert this value is not the formula's doing but the users. Because either a value or the result of a formula is valid, it is just very important to make them visually distinct. thanks ^ Impossible? bump |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cond Format if cell contains Values INSTEAD of a formula
On Aug 29, 2:44 pm, Finny388 wrote:
On Aug 27, 12:29 pm, Finny388 wrote: On Aug 27, 9:19 am, Finny388 wrote: On Aug 25, 11:24 am, Finny388 wrote: On Aug 24, 1:40 pm, Finny388 wrote: I cannot figure this out no matter what I do Every formula it try to apply addresses the RESULT of the formula (as it should) instead of the value. any solution much appreciated thanks Any help would be great. I need a way to highlight a cell if a text value has replaced the formula - to know alert this value is not the formula's doing but the users. Because either a value or the result of a formula is valid, it is just very important to make them visually distinct. thanks ^ Impossible? bump bump |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cond Format if cell contains Values INSTEAD of a formula
You need to add a user defined function to the workbook.
Enter this in a module: Public Function IsFormula(rng As Range) IsFormula = rng.HasFormula End Function Then highlight the cells needing CF, go to Conditional Formatting, choose "Formula Is" and type in the formula field: =IsFormula(A1) ....and set your desired format. (Change A1 in the formula to the upper-left cell of the range you highlighted.) Mark Lincoln On Aug 24, 2:40 pm, Finny388 wrote: I cannot figure this out no matter what I do Every formula it try to apply addresses the RESULT of the formula (as it should) instead of the value. any solution much appreciated thanks |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cond Format if cell contains Values INSTEAD of a formula
On Aug 30, 11:28 am, Mark Lincoln wrote:
You need to add a user defined function to the workbook. Enter this in a module: Public Function IsFormula(rng As Range) IsFormula = rng.HasFormula End Function Then highlight the cells needing CF, go to Conditional Formatting, choose "Formula Is" and type in the formula field: =IsFormula(A1) ...and set your desired format. (Change A1 in the formula to the upper-left cell of the range you highlighted.) Mark Lincoln On Aug 24, 2:40 pm, Finny388 wrote: I cannot figure this out no matter what I do Every formula it try to apply addresses the RESULT of the formula (as it should) instead of the value. any solution much appreciated thanks Thank you so much! That has been an issue for so long. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cond. formatting, based on other cell values? | Excel Discussion (Misc queries) | |||
Programming Formula for Cond. Format yields different formula | Excel Programming | |||
Make the result of a formula red (cannot be done in cond. format.) | Excel Discussion (Misc queries) | |||
How do I use cond format formula to set cell text and color? | Excel Discussion (Misc queries) | |||
Cond. Format & Absolute Cell Reference Question | Excel Discussion (Misc queries) |