Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format Issue
I have a column of calculated results. I have applied conditional formatting
to alternate colours per line, then to change the font colour for values between 90 and 95% and also to change colour and bold values under 90%. It is working fine on all but the first three values in the column. I have copied from the cells below and still get the same issued. I can't see any difference in the format or properties of these particular cells. Any thoughts? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format Issue
OK, Answering my own question, it appeard it only works where the background
colour format isn't applied. Is there a way for bot formula and cell value conditions to be considered? "Dean F" wrote: I have a column of calculated results. I have applied conditional formatting to alternate colours per line, then to change the font colour for values between 90 and 95% and also to change colour and bold values under 90%. It is working fine on all but the first three values in the column. I have copied from the cells below and still get the same issued. I can't see any difference in the format or properties of these particular cells. Any thoughts? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format Issue
It is probably relative referencing, but we can tell better if you show us
the CF formula. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Dean F" wrote in message ... I have a column of calculated results. I have applied conditional formatting to alternate colours per line, then to change the font colour for values between 90 and 95% and also to change colour and bold values under 90%. It is working fine on all but the first three values in the column. I have copied from the cells below and still get the same issued. I can't see any difference in the format or properties of these particular cells. Any thoughts? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format Issue
1. formula is: row()=even(row()) - format: pattern/colour blue
2. cell value is: between .9 and .95 - format: font red 3. cell value is: less than .9 - format font red and bold italic Thx Dean "Bob Phillips" wrote: It is probably relative referencing, but we can tell better if you show us the CF formula. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Dean F" wrote in message ... I have a column of calculated results. I have applied conditional formatting to alternate colours per line, then to change the font colour for values between 90 and 95% and also to change colour and bold values under 90%. It is working fine on all but the first three values in the column. I have copied from the cells below and still get the same issued. I can't see any difference in the format or properties of these particular cells. Any thoughts? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format Issue
Can you explain this bit
.... Is there a way for both formula and cell value conditions to be considered? -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Dean F" wrote in message ... 1. formula is: row()=even(row()) - format: pattern/colour blue 2. cell value is: between .9 and .95 - format: font red 3. cell value is: less than .9 - format font red and bold italic Thx Dean "Bob Phillips" wrote: It is probably relative referencing, but we can tell better if you show us the CF formula. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Dean F" wrote in message ... I have a column of calculated results. I have applied conditional formatting to alternate colours per line, then to change the font colour for values between 90 and 95% and also to change colour and bold values under 90%. It is working fine on all but the first three values in the column. I have copied from the cells below and still get the same issued. I can't see any difference in the format or properties of these particular cells. Any thoughts? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format Issue
It seems once the 'row()=....' condition is met, the subsequent conditions
aren't considered. I want to be able to set conditions based on that formula, as well as additional conditions based on the cell value. "Bob Phillips" wrote: Can you explain this bit .... Is there a way for both formula and cell value conditions to be considered? -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Dean F" wrote in message ... 1. formula is: row()=even(row()) - format: pattern/colour blue 2. cell value is: between .9 and .95 - format: font red 3. cell value is: less than .9 - format font red and bold italic Thx Dean "Bob Phillips" wrote: It is probably relative referencing, but we can tell better if you show us the CF formula. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Dean F" wrote in message ... I have a column of calculated results. I have applied conditional formatting to alternate colours per line, then to change the font colour for values between 90 and 95% and also to change colour and bold values under 90%. It is working fine on all but the first three values in the column. I have copied from the cells below and still get the same issued. I can't see any difference in the format or properties of these particular cells. Any thoughts? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format Issue
OK I see. You are right, it stops on a met condition. You need to AND the
conditions to get two at once =AND(cond1,cond2) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Dean F" wrote in message ... It seems once the 'row()=....' condition is met, the subsequent conditions aren't considered. I want to be able to set conditions based on that formula, as well as additional conditions based on the cell value. "Bob Phillips" wrote: Can you explain this bit .... Is there a way for both formula and cell value conditions to be considered? -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Dean F" wrote in message ... 1. formula is: row()=even(row()) - format: pattern/colour blue 2. cell value is: between .9 and .95 - format: font red 3. cell value is: less than .9 - format font red and bold italic Thx Dean "Bob Phillips" wrote: It is probably relative referencing, but we can tell better if you show us the CF formula. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Dean F" wrote in message ... I have a column of calculated results. I have applied conditional formatting to alternate colours per line, then to change the font colour for values between 90 and 95% and also to change colour and bold values under 90%. It is working fine on all but the first three values in the column. I have copied from the cells below and still get the same issued. I can't see any difference in the format or properties of these particular cells. Any thoughts? |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format Issue
Thanks, but I really need the conditions assessed separately; i.e. regardles
of the cell value, every other cell has the same pattern. I'll post if I figure a workaround. "Bob Phillips" wrote: OK I see. You are right, it stops on a met condition. You need to AND the conditions to get two at once =AND(cond1,cond2) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Dean F" wrote in message ... It seems once the 'row()=....' condition is met, the subsequent conditions aren't considered. I want to be able to set conditions based on that formula, as well as additional conditions based on the cell value. "Bob Phillips" wrote: Can you explain this bit .... Is there a way for both formula and cell value conditions to be considered? -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Dean F" wrote in message ... 1. formula is: row()=even(row()) - format: pattern/colour blue 2. cell value is: between .9 and .95 - format: font red 3. cell value is: less than .9 - format font red and bold italic Thx Dean "Bob Phillips" wrote: It is probably relative referencing, but we can tell better if you show us the CF formula. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Dean F" wrote in message ... I have a column of calculated results. I have applied conditional formatting to alternate colours per line, then to change the font colour for values between 90 and 95% and also to change colour and bold values under 90%. It is working fine on all but the first three values in the column. I have copied from the cells below and still get the same issued. I can't see any difference in the format or properties of these particular cells. Any thoughts? |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format Issue
I think you will need VBA. Example. Keep the striping CF, and then something
like '----------------------------------------------------------------- Private Sub Worksheet_Change(ByVal Target As Range) '----------------------------------------------------------------- Const WS_RANGE As String = "A1:H10" On Error GoTo ws_exit: Application.EnableEvents = False If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing Then With Target Select Case .Value Case 1: 'set something Case 2: 'set something Case 3: 'set something End Select End With End If ws_exit: Application.EnableEvents = True End Sub 'This is worksheet event code, which means that it needs to be 'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Dean F" wrote in message ... Thanks, but I really need the conditions assessed separately; i.e. regardles of the cell value, every other cell has the same pattern. I'll post if I figure a workaround. "Bob Phillips" wrote: OK I see. You are right, it stops on a met condition. You need to AND the conditions to get two at once =AND(cond1,cond2) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Dean F" wrote in message ... It seems once the 'row()=....' condition is met, the subsequent conditions aren't considered. I want to be able to set conditions based on that formula, as well as additional conditions based on the cell value. "Bob Phillips" wrote: Can you explain this bit .... Is there a way for both formula and cell value conditions to be considered? -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Dean F" wrote in message ... 1. formula is: row()=even(row()) - format: pattern/colour blue 2. cell value is: between .9 and .95 - format: font red 3. cell value is: less than .9 - format font red and bold italic Thx Dean "Bob Phillips" wrote: It is probably relative referencing, but we can tell better if you show us the CF formula. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Dean F" wrote in message ... I have a column of calculated results. I have applied conditional formatting to alternate colours per line, then to change the font colour for values between 90 and 95% and also to change colour and bold values under 90%. It is working fine on all but the first three values in the column. I have copied from the cells below and still get the same issued. I can't see any difference in the format or properties of these particular cells. Any thoughts? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Format - Format Transfer To Chart | Excel Discussion (Misc queries) | |||
Cell Format Changes When Data Is Entered - Not Conditional Formatt | Excel Worksheet Functions | |||
Conditional format question | Excel Discussion (Misc queries) | |||
Conditional Format Question | Excel Worksheet Functions | |||
Copying a conditional format | Excel Worksheet Functions |