Conditional Formatting in excel Based - Cells with and without Formulas

1. i need a CF to color cells without formulas  column 1
2. i need a CF to color cells with formulas       column 2
ansonindustriesAsked:
Who is Participating?
 
jppintoConnect With a Mentor Commented:
I've attached a working sample. I've used a UDF in VBA:

Function CellFormula(cel As Range) As String
    CellFormula = cel.Formula
End Function

This function will return the formula on a cell. Using this function on a Conditional Formatting rule, I check if the cell has a function (checking if it begins with a =) and on the first column, if it doesn't have a formula, I change the color (to yellow) on the second column, I check if it has a formula and if true change the color to orange.

Hope this is clear.

jppinto
ConditionalFormatting.xlsm
Capture.JPG
0
 
Raheman M. AbdulSenior Infrastructure Support Analyst & Systems DeveloperCommented:
0
 
Raheman M. AbdulSenior Infrastructure Support Analyst & Systems DeveloperCommented:
Replace with =NOT(IsFormula($B$3)) for the opposite function. ( is not the formula) select desired color
0
 
ansonindustriesAuthor Commented:
Thanks works great!
0
All Courses

From novice to tech pro — start learning today.