Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formulas\conditional formating
In my ss I have a cell say b1 with a formula in it. Under certain conditions
when this cell = another cell I have conditional formating turn the number to red. This color change indicates that you need to enter in the correct reading in place of the formula in the same cell. Is there a way that once the correct number is entered in place of the formula that it will chnage back to black. The number entered will still equal the other cell but I thought there may be a way since the formual is missing. Thanks Scott |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formulas\conditional formating
Add a UDF
Function IsFormula(rng As Range) IsFormula = rng.HasFormula End Function and than add that in the CF formula =AND(IsFormula(A10),A10=3) as an example -- HTH Bob Phillips (remove nothere from email address if mailing direct) "scott" wrote in message ... In my ss I have a cell say b1 with a formula in it. Under certain conditions when this cell = another cell I have conditional formating turn the number to red. This color change indicates that you need to enter in the correct reading in place of the formula in the same cell. Is there a way that once the correct number is entered in place of the formula that it will chnage back to black. The number entered will still equal the other cell but I thought there may be a way since the formual is missing. Thanks Scott |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formulas\conditional formating
Bob
I am not sure I understand. Wher do I put the formula you are suggesting "Bob Phillips" wrote: Add a UDF Function IsFormula(rng As Range) IsFormula = rng.HasFormula End Function and than add that in the CF formula =AND(IsFormula(A10),A10=3) as an example -- HTH Bob Phillips (remove nothere from email address if mailing direct) "scott" wrote in message ... In my ss I have a cell say b1 with a formula in it. Under certain conditions when this cell = another cell I have conditional formating turn the number to red. This color change indicates that you need to enter in the correct reading in place of the formula in the same cell. Is there a way that once the correct number is entered in place of the formula that it will chnage back to black. The number entered will still equal the other cell but I thought there may be a way since the formual is missing. Thanks Scott |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formulas\conditional formating
In a code module. In Excel, Alt-F11 to the VBIDE, insert a module,
InsertModule, and paste that code in. Then close the VBIDE and go back to Excl. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "scott" wrote in message ... Bob I am not sure I understand. Wher do I put the formula you are suggesting "Bob Phillips" wrote: Add a UDF Function IsFormula(rng As Range) IsFormula = rng.HasFormula End Function and than add that in the CF formula =AND(IsFormula(A10),A10=3) as an example -- HTH Bob Phillips (remove nothere from email address if mailing direct) "scott" wrote in message ... In my ss I have a cell say b1 with a formula in it. Under certain conditions when this cell = another cell I have conditional formating turn the number to red. This color change indicates that you need to enter in the correct reading in place of the formula in the same cell. Is there a way that once the correct number is entered in place of the formula that it will chnage back to black. The number entered will still equal the other cell but I thought there may be a way since the formual is missing. Thanks Scott |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula encompassing conditional formating | Excel Worksheet Functions | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
Conditional formating using formulas | Excel Worksheet Functions | |||
Cell to follow content AND/OR formating of another cell | Excel Discussion (Misc queries) | |||
Copy cell formating as part of a formula | Excel Worksheet Functions |