Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
I am trying to colour code some figures into Green, Amber & red relating to
what percentage has been achieved. In the following example I have got the red (under 80% working and the Green (over 100% but I CANNOT get the formula right for the amber section. =I6100% Green =I680%<99.999% Amber =I6<79.9999 Red Please can someone help - I am sure it is going to be sooo easy once someone tells me what I am doing wrong! I hope someone can help soon as it is driving me mad!! -- Lynn |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
Just colour the cell amber and avoid the conditional format. If one of the
Conditional Format conditions are met then it will override the colour. Otherwise it will leave the cell amber... -- HTH... Jim Thomlinson "Lynn Ash" wrote: I am trying to colour code some figures into Green, Amber & red relating to what percentage has been achieved. In the following example I have got the red (under 80% working and the Green (over 100% but I CANNOT get the formula right for the amber section. =I6100% Green =I680%<99.999% Amber =I6<79.9999 Red Please can someone help - I am sure it is going to be sooo easy once someone tells me what I am doing wrong! I hope someone can help soon as it is driving me mad!! -- Lynn |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
Whilst Jim is 100% correct, for future reference the formula you seek for
amber could be: =AND(I680%,I6<99.999%) "Jim Thomlinson" wrote: Just colour the cell amber and avoid the conditional format. If one of the Conditional Format conditions are met then it will override the colour. Otherwise it will leave the cell amber... -- HTH... Jim Thomlinson "Lynn Ash" wrote: I am trying to colour code some figures into Green, Amber & red relating to what percentage has been achieved. In the following example I have got the red (under 80% working and the Green (over 100% but I CANNOT get the formula right for the amber section. =I6100% Green =I680%<99.999% Amber =I6<79.9999 Red Please can someone help - I am sure it is going to be sooo easy once someone tells me what I am doing wrong! I hope someone can help soon as it is driving me mad!! -- Lynn |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
That is fantastic!
Thanks so much for your help - I knew something was missing!! Kind regards -- Lynn "Ron@Buy" wrote: Whilst Jim is 100% correct, for future reference the formula you seek for amber could be: =AND(I680%,I6<99.999%) "Jim Thomlinson" wrote: Just colour the cell amber and avoid the conditional format. If one of the Conditional Format conditions are met then it will override the colour. Otherwise it will leave the cell amber... -- HTH... Jim Thomlinson "Lynn Ash" wrote: I am trying to colour code some figures into Green, Amber & red relating to what percentage has been achieved. In the following example I have got the red (under 80% working and the Green (over 100% but I CANNOT get the formula right for the amber section. =I6100% Green =I680%<99.999% Amber =I6<79.9999 Red Please can someone help - I am sure it is going to be sooo easy once someone tells me what I am doing wrong! I hope someone can help soon as it is driving me mad!! -- Lynn |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |