conditional formatting in reports.

[Robbie]

In Reports I would like to colour the font according to
the value in another cell,

contract customer
99999 Barclays

I would like 99999 to be blue if customer = to barclays

in conditional formatting it only lets me change the
colour based on the selected field (contract) and not a
different field (customer).

cheers
Robbie

 

[Nikos Yannacopoulos]

Robbie,

Conditional formatting will let you vbase your criterion on another
field if you cange the default "Field value Is" to "Condition Is" in the
drop-down in the condition setup wizard; this done, the expression
should be something like
[Customer] = 'Barclays'

HTH,
Nikos

 

[fredg]

In Reports I would like to colour the font according to
the value in another cell,

contract customer
99999 Barclays

I would like 99999 to be blue if customer = to barclays

in conditional formatting it only lets me change the
colour based on the selected field (contract) and not a
different field (customer).

cheers
Robbie
Regarding:
in conditional formatting it only lets me change the
colour based on the selected field (contract) and not a
different field (customer). <

The above is not correct.
Change the Field Value Is dropdown to
Expression Is
In the next box write:
[Customer] = "Barclays"