conditional format

  • Thread starter Thread starter Yossy
  • Start date Start date
Y

Yossy

How do I write a conditional format to this situation?

If cell(s) in a column is formula, color brown.

Formula can be e.g =34567-12343 or =e27-6700
 
Copy/paste this UDF to a general module in your workbook.

Function IsFormula(Cell)
IsFormula = Cell.HasFormula
End Function

In CF>Formula is: =isformula(cellref)


Gord Dibben MS Excel MVP
 
Hi,

Create a name such as isFormula:
1. Choose Insert, Name, Define and enter isFormula in the Names in Workbook
box
2. Enter the following formula in the Refers to box
=GET.CELL(48,INDIRECT("rc",))
3. Highlight the range you want conditionally formatted and choose Format,
Conditional Formatting
4. Pick Formula is from the first drop down
5. Enter =isFormula in the second box
6. Click Format...
 
One way:

Select cell A1. Choose Insert/Name/Define and define a name, say,
"mycell" as:

Names in workbook: mycell
Refers to: =GET.CELL(6,!A1)


Select the cells to CF. Choose Format/Conditional Formatting, and set
the dropdowns and input box to read:

Formula is =LEFT(mycell, 1) = "="

and choose the desired format.
 
Back
Top