Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Conditional formatting problem

Status
Not open for further replies.
ryangus

ryangus

IS-IT--Management
May 19, 2002
14
AU
I have an anticipated completion date, and a completion date. If the completion date is null, and the anticipated completion date is prior to the current date, I want the anticipated date to show up in bold red. Can someone please help with the formula?
 
Sort by date Sort by votes
Font Color Condition formula to turn Red:

if IsNull ({complete}) and {Anticipate} < CurrentDate
then Red
else Black

To get bold, you would also have to write the same formula for the appropriate Font property condition. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB
- tek@kenhamady.com
 
Upvote 0 Downvote
Thank Ken,

I managed to work it out just before I was about to check back here!

Regards,
Ranga
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

jchewsmith
  • Locked
  • Question
Formatting an embedded field in Crystal 2016 Support Pack 5 1
Replies
3
Views
250
BobSuruncle
BobSuruncle
Cpreston
  • Locked
  • Question
Remaining Text does not appear problem 2
Replies
10
Views
335
Cpreston
Cpreston
GCL2007
  • Locked
  • Question
Formatting hyperlink on exported document
Replies
0
Views
101
GCL2007
GCL2007
wld1957
  • Locked
  • Question
Report Form Problem - What can it be? 1
Replies
3
Views
120
wld1957
wld1957
n2nuk
  • Locked
  • Question
formatting a date within a concatenated field 1
Replies
8
Views
175
n2nuk
n2nuk

Part and Inventory Search

Sponsor

Back
Top