Other backgroundcolor by another value in the same column

  • Thread starter Thread starter johan
  • Start date Start date
J

johan

Hello,

I like to have a solution.
In my formview I have one column with a lot of sorted records like....

aaa
aaa
bbb
ccc
ccc
ccc
ddd

Because of a better overview I want the backgroundcolor set, for
example, to red if the
value is different then the value in the record before (in the same
column !!).
The result is that the records with the "x" should get a red colored
background.

aaa x
aaa
bbb x
ccc x
ccc
ccc
ddd x

I want do see this in my form and if possible in my report.
Is it possible on a conditional formating way ? or do I need a module?
Can somebody give me the solution.

regards,
Johan.
 
Using Conditional Formatting, you could specify up to 4 different
colors
(3 conditional, 1 default).

I have not been successful in using code to do this.

HTH
Bubbles
 
Back
Top