Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Target cell coloured based on whether one cell has a greater value
I have a table with 4 statuses e.g. green, amber, red and blue.
I have a target cell which I want to be coloured according to which colour is the predominant one. So, if the value under 'green' is greater than the value for 'amber', 'red' or 'blue', I want the target cell to be coloured green. Likewise, if the value under 'amber' is greater than the value for 'green', 'red' or 'blue', I want the target cell to be coloured amber. So far, I have tried conditional formatting, but no joy. Any advice gratefully received. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Target cell coloured based on whether one cell has a greater value
I am not going to do it all for you, but conditional formatting works.
The conditional format in your target cell should have 3 conditions. You will need to use FORMULA IS =A1=MAX(A1:D1), colour 1 FORMULA IS =B1=MAX(A1:D1), colour 2 FORMULA IS =C1=MAX(A1:D1), colour 3 and the other colour (if D1 is the greatest) will be the default normal colour that you set for the cell. Conditional formatting only offers you 3 colours, so if you need more than that you will need some programming help. -- Allllen "Kierano" wrote: I have a table with 4 statuses e.g. green, amber, red and blue. I have a target cell which I want to be coloured according to which colour is the predominant one. So, if the value under 'green' is greater than the value for 'amber', 'red' or 'blue', I want the target cell to be coloured green. Likewise, if the value under 'amber' is greater than the value for 'green', 'red' or 'blue', I want the target cell to be coloured amber. So far, I have tried conditional formatting, but no joy. Any advice gratefully received. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Target cell coloured based on whether one cell has a greater v
Thanks Alllen. This does solve about 80% of it. However, I do need to do this
for 4 colours, so I guess I need to investigate worksheet_change() or worksheet_calculate() event macros. "Allllen" wrote: I am not going to do it all for you, but conditional formatting works. The conditional format in your target cell should have 3 conditions. You will need to use FORMULA IS =A1=MAX(A1:D1), colour 1 FORMULA IS =B1=MAX(A1:D1), colour 2 FORMULA IS =C1=MAX(A1:D1), colour 3 and the other colour (if D1 is the greatest) will be the default normal colour that you set for the cell. Conditional formatting only offers you 3 colours, so if you need more than that you will need some programming help. -- Allllen "Kierano" wrote: I have a table with 4 statuses e.g. green, amber, red and blue. I have a target cell which I want to be coloured according to which colour is the predominant one. So, if the value under 'green' is greater than the value for 'amber', 'red' or 'blue', I want the target cell to be coloured green. Likewise, if the value under 'amber' is greater than the value for 'green', 'red' or 'blue', I want the target cell to be coloured amber. So far, I have tried conditional formatting, but no joy. Any advice gratefully received. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert date | Excel Worksheet Functions | |||
Create formula that will pull a value based on text in diff cell? | Excel Discussion (Misc queries) | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
HELP| populate cell with particular value based on multiple condit | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions |