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.










In article ,
Yossy wrote:

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