More than 3 conditional formats in datasheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Has anyone figured out how to apply more than 3 conditional formats to a
datasheet (or continuous) view form? Or, in lieu of that, how to show more
than 3 colors - based, say, on a name in one of the fields.

I've seen the Frank Rice blog and the Stephan Lebans stuff, and I don't
think they've addressed what I want to do.

Thanks
 
Actually, you can have 4 without any coding. I had to do this for one of our
management reports. Depending on certain criteria, the background had to be
either red, yellow, green, or blue, and for red and blue, they wanted white
text. Only 3 choices, right? Well, I set one up in form design as red with
white text, then I added the other 3 conditions to get the colors I needed.
So, in reality, you have 4 choices.

If you need more than that, you will have to do it with code.

Good Luck
 
Klatuu said:
Actually, you can have 4 without any coding. I had to do this for one of our
management reports. Depending on certain criteria, the background had to be
either red, yellow, green, or blue, and for red and blue, they wanted white
text. Only 3 choices, right? Well, I set one up in form design as red with
white text, then I added the other 3 conditions to get the colors I needed.
So, in reality, you have 4 choices.
Click to expand...

Yes, the base plus up to 3 conditional formats. But I need 5 or 6 or 7
conditional formats.

If you need more than that, you will have to do it with code.
Click to expand...

I don't think it can be done with code.
 
Well, it can be done in code, but it applies to the entire datasheet. If
this is not what you want, then I don't know if it can be done.
 
Klatuu said:
Well, it can be done in code, but it applies to the entire datasheet. If
this is not what you want, then I don't know if it can be done.
Click to expand...

More than 3 FormatConditions cannot be done in code.

But yes, if I don't mind the colors applying to the entire datasheet I can
add an unlimited number of conditions specifying colors to the Current event,
or wherever. But I don't need and don't see the point of coloring all the
rows of the datasheet.

Thanks
 
Back
Top