Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional Formatting based on a value in another cell
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional Formatting based on a value in another cell
Use conditional formatting:
Condition1: Formula Is: =R300 (format green) Add Condition2: Formula Is: =R30<0 (format red) Add Condition3: Formula Is: =R30=0 (format yellow) -- "Actually, I *am* a rocket scientist." -- JB Your feedback is appreciated, click YES if this post helped you. "Brian" wrote: I want to put a green data bar if the value in R30 is 0 or a Red data bar if R30 is < 0 , and finally a yellow data bar if R30 = 0. I am calculating math test scores. Thanks Brian |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional Formatting based on a value in another cell
Select the entire range of cells you want to apply this CF. Go to Format|
Conditional Formatting. You can define your three conditions here. If you encounter any problem, post here -- R. Khoshravan Please click "Yes" if it is helpful. "Brian" wrote: I want to put a green data bar if the value in R30 is 0 or a Red data bar if R30 is < 0 , and finally a yellow data bar if R30 = 0. I am calculating math test scores. Thanks Brian |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional Formatting based on a value in another cell
Ok, now I've just been told to put a Green arrow and the Data bar?? can I do
both? Brian "JBeaucaire" wrote: Use conditional formatting: Condition1: Formula Is: =R300 (format green) Add Condition2: Formula Is: =R30<0 (format red) Add Condition3: Formula Is: =R30=0 (format yellow) -- "Actually, I *am* a rocket scientist." -- JB Your feedback is appreciated, click YES if this post helped you. "Brian" wrote: I want to put a green data bar if the value in R30 is 0 or a Red data bar if R30 is < 0 , and finally a yellow data bar if R30 = 0. I am calculating math test scores. Thanks Brian |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional Formatting based on a value in another cell
Could you please explain what do you mean by: "Green arrow".
You already changed the color so they are distinctive, what would be the function of this green arrow? Unless you want to define another condition. -- R. Khoshravan Please click "Yes" if it is helpful. "Brian" wrote: Ok, now I've just been told to put a Green arrow and the Data bar?? can I do both? Brian "JBeaucaire" wrote: Use conditional formatting: Condition1: Formula Is: =R300 (format green) Add Condition2: Formula Is: =R30<0 (format red) Add Condition3: Formula Is: =R30=0 (format yellow) -- "Actually, I *am* a rocket scientist." -- JB Your feedback is appreciated, click YES if this post helped you. "Brian" wrote: I want to put a green data bar if the value in R30 is 0 or a Red data bar if R30 is < 0 , and finally a yellow data bar if R30 = 0. I am calculating math test scores. Thanks Brian |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting a row based on a value in a cell | Excel Discussion (Misc queries) | |||
Conditional Formatting based on a cell value | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional formatting based on another cell | Excel Discussion (Misc queries) |