Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I need 5 conditional formatting rules-excel only allows 3
Im trying to set a sheet of fixed numbers (120) and need to have the chart
highlight the numbers that match the five random numbers selected. Conditional formatting would work if it would let me use 5 rules but it only lets me use up to 3. I'm trying to highlight all the chart and then make rules to highlight in orange if any cell in the chart matches the numbers I input in each if the 5 cells at the top of the page. Any suggestions? Thanks David |
#2
|
|||
|
|||
I need 5 conditional formatting rules-excel only allows 3
The next version of XL will permit you all you want, but until then, check
out this link: http://www.xldynamic.com/source/xld.....Download.html -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "das1997" wrote in message ... Im trying to set a sheet of fixed numbers (120) and need to have the chart highlight the numbers that match the five random numbers selected. Conditional formatting would work if it would let me use 5 rules but it only lets me use up to 3. I'm trying to highlight all the chart and then make rules to highlight in orange if any cell in the chart matches the numbers I input in each if the 5 cells at the top of the page. Any suggestions? Thanks David |
#3
|
|||
|
|||
I need 5 conditional formatting rules-excel only allows 3
See:
http://www.xldynamic.com/source/xld.....Download.html Hope this helps Rowan das1997 wrote: Im trying to set a sheet of fixed numbers (120) and need to have the chart highlight the numbers that match the five random numbers selected. Conditional formatting would work if it would let me use 5 rules but it only lets me use up to 3. I'm trying to highlight all the chart and then make rules to highlight in orange if any cell in the chart matches the numbers I input in each if the 5 cells at the top of the page. Any suggestions? Thanks David |
#4
|
|||
|
|||
I need 5 conditional formatting rules-excel only allows 3
Hi,
You can achieve this with a single condition. Let's suppose that the five random numbers are in A1, B1, ... E1, and the fixed numbers start at A3 and are in a range (single or multiple columns, it doesn't matter). Highlight the entire range of the fixed numbers (e.g., A3:A122 or A3:D32) and in Conditional Formatting use the following formula: Formula Is =OR(A3=$A$1,A3=$B$1,A3=$C$1,A3=$D$1,A3=$E$1) and format the cell shading to orange. Regards, B. R. Ramachandran "das1997" wrote: Im trying to set a sheet of fixed numbers (120) and need to have the chart highlight the numbers that match the five random numbers selected. Conditional formatting would work if it would let me use 5 rules but it only lets me use up to 3. I'm trying to highlight all the chart and then make rules to highlight in orange if any cell in the chart matches the numbers I input in each if the 5 cells at the top of the page. Any suggestions? Thanks David |
#5
|
|||
|
|||
I need 5 conditional formatting rules-excel only allows 3
Thank you so much for the info! Have a Great Weekend!
"B. R.Ramachandran" wrote: Hi, You can achieve this with a single condition. Let's suppose that the five random numbers are in A1, B1, ... E1, and the fixed numbers start at A3 and are in a range (single or multiple columns, it doesn't matter). Highlight the entire range of the fixed numbers (e.g., A3:A122 or A3:D32) and in Conditional Formatting use the following formula: Formula Is =OR(A3=$A$1,A3=$B$1,A3=$C$1,A3=$D$1,A3=$E$1) and format the cell shading to orange. Regards, B. R. Ramachandran "das1997" wrote: Im trying to set a sheet of fixed numbers (120) and need to have the chart highlight the numbers that match the five random numbers selected. Conditional formatting would work if it would let me use 5 rules but it only lets me use up to 3. I'm trying to highlight all the chart and then make rules to highlight in orange if any cell in the chart matches the numbers I input in each if the 5 cells at the top of the page. Any suggestions? Thanks David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel changing number formatting and source data in graphs on it's own!!! | Excel Discussion (Misc queries) | |||
increase conditional formatting in Excel | Excel Worksheet Functions | |||
Conditional Formatting in Excel Help Please..... | Excel Discussion (Misc queries) | |||
Adding more than three Conditions to 'Conditional Formatting' | Excel Discussion (Misc queries) | |||
Conditional Formatting | Excel Worksheet Functions |