B
Brennan
Hello:
I have a report in which the detail records has a field
called Status. Based upon the value of the of that field,
I would like to change the detail record to a specific
color.
Someone suggested using Conditional Formatting to
accomplish this. I tried using this and have several
problems. First, I need to change all of the field in the
line item, not just the Status field. In this case, there
are 6 other fields that make up a complete record. I want
to change the font color of all of them not just the
status field.
Problem 2 is that I am only allowed a combination of 3
conditions. In this case, I have 6 possible conditions
all of which would be color-coded differently.
It seems that I need to create some type of VBA code to
accomplish this. I am playing with some IF statements but
am not having much luck.
Any help would be appreciated
Thanks
Brennan
I have a report in which the detail records has a field
called Status. Based upon the value of the of that field,
I would like to change the detail record to a specific
color.
Someone suggested using Conditional Formatting to
accomplish this. I tried using this and have several
problems. First, I need to change all of the field in the
line item, not just the Status field. In this case, there
are 6 other fields that make up a complete record. I want
to change the font color of all of them not just the
status field.
Problem 2 is that I am only allowed a combination of 3
conditions. In this case, I have 6 possible conditions
all of which would be color-coded differently.
It seems that I need to create some type of VBA code to
accomplish this. I am playing with some IF statements but
am not having much luck.
Any help would be appreciated
Thanks
Brennan