Conditional Formatting Values vs. Formulas
Closed
Tim
-
Apr 16, 2010 at 05:00 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 16, 2010 at 05:57 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 16, 2010 at 05:57 AM
Related:
- Conditional Formatting Values vs. Formulas
- Little alchemy formulas - Guide
- Apply conditional formatting to the selected cells ✓ - Excel Forum
- Excel formula to change cell color without conditional formatting - Excel Forum
- How to clear formatting in excel - Guide
- Excel conditional formatting if another cell contains specific text - Excel Forum
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Apr 16, 2010 at 05:57 AM
Apr 16, 2010 at 05:57 AM
You may have to create a User defined function
Function isFormula (cell as range) as boolean
isFormula =cell.HasFormula
end function
then use this UDF in your conditional format
Function isFormula (cell as range) as boolean
isFormula =cell.HasFormula
end function
then use this UDF in your conditional format