2014-02-19, 09:06 #1
- Join Date
- Mar 2012
- Thanked 0 Times in 0 Posts
Iif statement in access query with color criteria
I am trying to alter the following IIF Statement:
IIF(IsNull([Diff],"",IIF([Diff]>0, "Over","Not Over"))
This is working correctly but I was wondering if there was a way to add in a light gray highlight when the conditional is "Over"? This IIF statement is in an Access query. Ideally I would like the entire row to highlight where the condition is "Over".
Subscribe to our Windows Secrets Newsletter - It's Free!
Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!
+ Get this BONUS — free!
Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!
2014-02-19, 17:55 #2
- Join Date
- Aug 2001
- Evergreen, CO, USA
- Thanked 42 Times in 42 Posts
Unfortunately there isn't a way of doing that in a query. However, with conditional formatting, you can display the results of a query on a form or report. See Using Conditional Formatting in Access 2010 Reports for details on how to do it for reports. This Change the appearance of a control... is a bit less technical look at both forms and reports.Wendell