|
|
Conditional Formatting Query
Hi
I'm facing a problem from last month but I'm not able to put conditional
formatting with Icons.
If somebody can help as its really urgent for me !!!!!
I have values for two months - Current and Previous. If current month's
value is closer to zero than previous month's value then i want to show a
green arrow. If current month's value is away from zero than previous
month's value then i want to show a red arrow. Though these values are
positive and negative both, i need to apply conditional formatting on
absolute values.
e.g.
previous Current Arrow Colour
1.2% 2.4% Red Arrow
1.2% -2.4% Red Arrow
-1.2% 2.4% Red Arrow
-1.2% -2.4% Red Arrow
-2.4% 1.2% Green Arrow
-2.4% -1.2% Green Arrow
2.4% -1.2% Green Arrow
2.4% 1.2% Green Arrow
But the conditional formatting will be applied on absolute values and I want
to put the condition in same cell in which the current month values are
shown.
Any help will be appreciated..
Regards,
Miki
|
|
0
|
|
|
|
Reply
|
 Utf
|
3/6/2010 8:53:01 AM |
|
see your other post
--
Mike
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
"Miki" wrote:
> Hi
>
> I'm facing a problem from last month but I'm not able to put conditional
> formatting with Icons.
>
> If somebody can help as its really urgent for me !!!!!
>
> I have values for two months - Current and Previous. If current month's
> value is closer to zero than previous month's value then i want to show a
> green arrow. If current month's value is away from zero than previous
> month's value then i want to show a red arrow. Though these values are
> positive and negative both, i need to apply conditional formatting on
> absolute values.
>
> e.g.
>
> previous Current Arrow Colour
> 1.2% 2.4% Red Arrow
> 1.2% -2.4% Red Arrow
> -1.2% 2.4% Red Arrow
> -1.2% -2.4% Red Arrow
>
> -2.4% 1.2% Green Arrow
> -2.4% -1.2% Green Arrow
> 2.4% -1.2% Green Arrow
> 2.4% 1.2% Green Arrow
>
> But the conditional formatting will be applied on absolute values and I want
> to put the condition in same cell in which the current month values are
> shown.
>
> Any help will be appreciated..
>
> Regards,
> Miki
>
|
|
|
0
|
|
|
|
Reply
|
Utf
|
3/6/2010 10:10:01 AM
|
|
|
1 Replies
337 Views
(page loaded in 0.028 seconds)
Similiar Articles: Conditional formatting based on matching record in separate query ...I would like to conditionally format a patient's name (e.g., Bold) in a report, based on whether it finds that name in a separate query of New Adm... DLookup in Conditional Formatting? - microsoft.public.access.forms ...Conditional formatting based on matching record in separate query ... Will conditional formatting ... me add any records. I really don't want to have a separate ... and ... Conditional formatting based on Column header - microsoft.public ...Then Conditional Format the Quantities field > for the current month using the Expression ... BCE Item3 #6/1/07# 20 17 You can create a Crosstab Query to spread ... Default Conditional Formatting Grayed Out in Subform? 2007 ...Thought I would could do this via Conditional Formatting by setting 3 ... Default Conditional Formatting Grayed Out in Subform? 2007 ... query builder grayed out ... Conditional Formating based on Data Validation - microsoft.public ...... colours based on the option selected (e.g., On Order, Fitted, Query etc ... As far as I know, conditional formatting changes cells format based on the value of the cell ... Building a conditional expression in Access - microsoft.public ...I am trying to build a conditional expression in an Access query that will tell me how many ... Calling function in conditional formatting expression - microsoft ... ... Conditional Formatting - Comparing field on form to field on a ...Access Help and How-to - Microsoft Office conditional formatting ..... Query to rename the 2 Fields named [Historic] to 2 distinct Field names so that the Form ... same ... Conditional format duplicates - microsoft.public.access ...I would like ot highlight those in the form, like in Excel, with conditional formatting. ... untested) which might work is to include a calculated field in a query ... Calculated Conditional Expressions - microsoft.public.access ...Display the lesser of two DateDiff expressions - microsoft.public ... Conditional Formatting ... For example: Total: IIf([field1]>0,1,0 ... expression in an Access query ... Conditional Formatting Access 2007 - microsoft.public.access ...On Thu, 1 Mar 2007 10:34:06 -0800, cage4000 <cage4000@discussions ... formatting on a datasheet Displaying Access Query results with conditional formatting. Displaying Access Query results with conditional formattingDisplaying Access Query results with conditional formatting. Access tables and queries are not designed to retain formatting features such as fonts and colours. Conditional Formatting in a queryHi Guys, Access 2000. I have a crosstab query with a date field "Expiration Date". When the date in the field becomes older than today, I want there to be some flag ... Conditional Formatting Query - Microsoft AnswersSelect AR1. Choose Conditiona Formatting->New Rule. Choose 'Use a formula...' at the Rule Type. Paste this formula =(AQ1-AP1)>15. Choose the format you want Conditional Formatting at the Query View.: Microsoft, Access 2003 ...Hi! I need to make a conditional formatting of a query (using Expression Builder). I want to show the positive values with green and the negative with red. Microsoft: Access Forms - Conditional Formatting and QueryHi, I have a query 'MissingMemoDetails' that selects records based whether there is particular missing data in a record, the form 'AccessSearch' i have open is a list ... 7/30/2012 9:44:21 AM
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
39 followers. 