SageForum for UK versions of Sage 50- Help and support.

Hi,

Can you conditional format on anything?

Im trying to format colour background.

if COMPONENT.STOCK_CAT = 60 OR COMPONENT.STOCK_CAT = 30
then
begin
TextStyle->Italic := True;
TextStyle->FontName := "Sitka Text";
Background := Solid
Colour("Transparent");;
TextStyle->Size := 9;TextStyle->Color := NamedColor("Black");;
end

The above is my expression everything was working correctly until ive guessed the
synatx to add the border colour condition:

Background := Solid
Colour("Transparent");;

Thanks
Gareth

The border is not an option.

The available options are shown in the wizard.
However, you could add a text box around the subject and then suppress printing with a conditional format to get the result you are looking for.

Hi Bruce,

Thanks for the quick reply much appreciated

So its literally only options below the expanded "Text Style" menu only?


if COMPONENT.STOCK_CAT = 60 OR COMPONENT.STOCK_CAT = 30 then
begin
TextStyle->Italic := True;
TextStyle->FontName := "Sitka Text";
TextStyle->Color := NamedColor("Gray");;
end
That is my current conditional formatting. This is a BOM report (the source material/primary BOM is always component 1, later components are Packaging (Cat 60 Pails. Cat 30 Labels). I wanted the primary feedstock (component 1) to stand out with dark grey fill. By having standard formatting dark grey fill.
If cant be done with work around I'll just leave as is.

Many Thanks

No

You can use all the attributes exposed eg suppress print.

Background colour is one of the options, not sure what your issue is?

I thought you were wanting a border setting.

ive guessed the synatx to add the border colour condition:

The way to do that is to draw a box around the item set it as suppressed printing, then use conditional formatting to unsuppress it when you want it to show.

Hi bruce,

Typo by me was wondering why you kept mentioning border.
No it was background colour, dont know the syntax to specify in conditional formatting so was guessingt how to apply grey fill.

So just select grey and the job is done.