trishcollins
Registered User.
- Local time
- Today, 00:49
- Joined
- Mar 23, 2011
- Messages
- 42
Is it possible to apply conditional formatting on a field in a report based on the column number relative to other columns. ie Jan is in column 2, Feb is in column 3, Mar is in Column 4? The conditional formatting is to identify the fields which are "future" and only estimates, based on the fiscal year filter for the report and the current date.
Here is the condition formatting I want to apply, but I want the number to increase relative to the what column it's in.
([Forms]![NSB Dynadocs Inventory Report Query Form]![Fiscal_Year]=DatePart("yyyy",Now()) And DatePart("m",Now())<1)
The "1" currently stands for Jan. Right now, I would have to go in a replace the 1 with a 2 for conditional formatting to apply to the Feb column, etc.
Instead, I would like to replace the "1" with a variable that pulls the column position number, so I don't have to edit each individual conditional formatting (which given I sum the data three times, is a lot of work). For example, if the variable was called "column_number", then I would repace the "1" with "column_number -1" to get the right number relative to the month.
Is this possible?
Thanks in advance...Trish
Here is the condition formatting I want to apply, but I want the number to increase relative to the what column it's in.
([Forms]![NSB Dynadocs Inventory Report Query Form]![Fiscal_Year]=DatePart("yyyy",Now()) And DatePart("m",Now())<1)
The "1" currently stands for Jan. Right now, I would have to go in a replace the 1 with a 2 for conditional formatting to apply to the Feb column, etc.
Instead, I would like to replace the "1" with a variable that pulls the column position number, so I don't have to edit each individual conditional formatting (which given I sum the data three times, is a lot of work). For example, if the variable was called "column_number", then I would repace the "1" with "column_number -1" to get the right number relative to the month.
Is this possible?
Thanks in advance...Trish
