Recent content by sdzc

The white on white is a good idea, but I have two users who need to use this one frequently and they are not technical (want it easy), so this would not work for them. As for the names on the report, the Data1, Data2 etc. examples were not real. Those were just to show there would be a...

I am trying to use one spreadsheet that is based off of another and have it all set up like I need it, but I cannot conditionally format anything because the data is based on another spreadsheet. So my thought is to move everything to the same workbook, but is there a way to lock or secure the...

I tried that and it did not work for some reason. The only way I could get it was to copy paste each individual cell. Don't know why that would have been an issue with it.

Figured it out. Needed to take the $ out of the formula: =(COUNTIF(Relief,$B$2:$K$21)>0) Actually changed the formula to: =(COUNTIF(Relief,B2)>0) with the location portion remaining as $B$2. This allowed me to copy and paste one cell at a time and the formulas changed automatically to adjust...

I was able to figure it out, but only in a manual sense. I did a copy/paste special for the formats, but I have to manually change the =(COUNTIF(Relief,$B$2:$K$21)>0) formula for the $B$2 to the location of the cell I want to conditionally format. the problem with this is that I have a range...

Thank you both for your responses. To simplify things, I moved the range to the same worksheet and set a print area so that info would not print. I was able to get it to highlight the single cell based on conditional formatting, thank you! The next step is to get it to apply the formatting...

Is it possible to conditionally format based on a range named either in the same worksheet or in another worksheet? For example, if John Doe is entered in a cell on Worsheet1, can the cell be highlighted if the name John Doe is a part of the range of "Vendor"?

That fixed it. Thank You!!

Conditional formatting was done by right clicking the AvgofAmount box on the Detail line of the Report. Thanks for the quick reply I think the gray line is because there are three lines of data and it is calling the middle one out to define its data (Is there a way to turn this off?)

Access 2007 Some of the formatting in a report is acting odd and I do not know why: Conditional formatting is not showing unless you click on it, then it goes away (and does not print) One line in the Detail section has a gray background and the others in the same section do not. Any ideas?

Bob!! One last question.. Last attempt at a answer.

Just a bump, hoping for an answer Just a bump, hoping for an answer to my last post.

Bob (or anyone else): Another question has come up. When we move too quickly from record to record, the database will "crash" and want to do a recovery. I believe this is because the pictures are not given enough time to load while moving between records. Anything we can do to keep this from...

Again, that worked!! Thank you so much!!

That worked, thank you!! I did notice, however, that the picture stays in the frame even when you move off that record to a record in which there is no picture path. Is there a way to get the frame (picture) to go blank when there is no path in the field? Hope this makes sense.