MS Access 2003 - Conditional Formatting...

[Ryman1986]

Hi all
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
Hope someone can help!
<o> </o>
I was asked to design an action register for our department at work so I developed the tool in MS Excel, but it was then agreed that they wanted the register in MS Access instead to enable multiple users entering information at any one time.
<o> </o>
I have copied everything over from excel to access, apart from one part…the conditional formats:
<o> </o>
The excel conditional formats were as follows:
<o> </o>
1 - =IF($H57>0,TRUE,FALSE) turn the background of the cells in this row grey.
<o> </o>
2 - =IF($F57<=$a$1,TRUE,FALSE) turn the background of the cells in this row red.
<o> </o>
3 - =IF($F57<=$a$2,TRUE,FALSE) turn the background of the cells in this row orange.
<o> </o>
Cell A1 - “=Today()“
Cell A2 – “=Today()+7”
<o> </o>
Please see below how the excel and access fields match up:
<o> </o>
Excel – Access <o></o>
Column A – [ActionID]
Column B – [BusinessArea/Meeting]
Column C – [DateRaised]
Column D – [ActionDescription]
Column E – [Owner]
Column F – [DueDate]
Column G – [Comments]
Column H – [CompletionDate]
<o> </o>
Can anyone inform me of how to convert the MS Excel conditional format formulas into expressions for MS Access conditional formats?
<o> </o>
Many thanks
<o> </o>
Ry

 

[alansidman]

Here is a web site with detailed instructions on Conditional Formatting

http://www.databasedev.co.uk/conditional-formatting.html

http://www.databasedev.co.uk/conditional_report_formatting.html

http://www.databasedev.co.uk/conditional_formatting.html

HTH
Alan