Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formating
My data table looks like this
A B C D E F QQQQ 8.52% 3.31% 20.65% 33.18% 16.11% 18.23% AAPL 3.04% 4.59% 24.84% 27.91% 18.27% 21.35% SPY 4.34% 5.00% 47.32% 19.28% 4.37% 19.70% ..SPX 0.00% 0.00% 100.00% 0.00% 0.00% 0.00% IWM 3.49% 2.33% 22.51% 16.43% 50.38% 4.87% XLF 5.21% 1.10% 14.86% 53.95% 23.33% 1.55% AMGN 4.59% 2.46% 64.98% 20.41% 3.81% 3.76% ..RUT 25.90% 1.96% 28.57% 40.44% 1.33% 1.80% MO 25.68% 5.59% 14.62% 35.64% 11.59% 6.89% ..VIX 0.00% 0.00% 100.00% 0.00% 0.00% 0.00% GE 2.89% 5.60% 15.66% 52.26% 12.27% 11.32 Can I use the Conditional Format to highlight the rows were the value in ColB is less than 3% and any other value in the row is greater than 50% ? Thank you in advance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formating
Yes you can. Highlight all of the data and on condition one you will choose
formula is and type in =$B2<3 and then click add and on condition two you will click cell value is and choose greater than or equal too or just greater than and a drop down box will appear and click the value that you want. Choose your formatting from the format box and it should work. "carl" wrote: My data table looks like this A B C D E F QQQQ 8.52% 3.31% 20.65% 33.18% 16.11% 18.23% AAPL 3.04% 4.59% 24.84% 27.91% 18.27% 21.35% SPY 4.34% 5.00% 47.32% 19.28% 4.37% 19.70% .SPX 0.00% 0.00% 100.00% 0.00% 0.00% 0.00% IWM 3.49% 2.33% 22.51% 16.43% 50.38% 4.87% XLF 5.21% 1.10% 14.86% 53.95% 23.33% 1.55% AMGN 4.59% 2.46% 64.98% 20.41% 3.81% 3.76% .RUT 25.90% 1.96% 28.57% 40.44% 1.33% 1.80% MO 25.68% 5.59% 14.62% 35.64% 11.59% 6.89% .VIX 0.00% 0.00% 100.00% 0.00% 0.00% 0.00% GE 2.89% 5.60% 15.66% 52.26% 12.27% 11.32 Can I use the Conditional Format to highlight the rows were the value in ColB is less than 3% and any other value in the row is greater than 50% ? Thank you in advance. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formating
Thanks. This does not work. I probably did not explain my problem well enough.
I need the Conditional Format to highlight only the rows were the value in ColB is less than 3% and any other value in the row is greater than 50% ? Seems like it would be an IF/AND problem ? Any thoughts ? "Darrilyn" wrote: Yes you can. Highlight all of the data and on condition one you will choose formula is and type in =$B2<3 and then click add and on condition two you will click cell value is and choose greater than or equal too or just greater than and a drop down box will appear and click the value that you want. Choose your formatting from the format box and it should work. "carl" wrote: My data table looks like this A B C D E F QQQQ 8.52% 3.31% 20.65% 33.18% 16.11% 18.23% AAPL 3.04% 4.59% 24.84% 27.91% 18.27% 21.35% SPY 4.34% 5.00% 47.32% 19.28% 4.37% 19.70% .SPX 0.00% 0.00% 100.00% 0.00% 0.00% 0.00% IWM 3.49% 2.33% 22.51% 16.43% 50.38% 4.87% XLF 5.21% 1.10% 14.86% 53.95% 23.33% 1.55% AMGN 4.59% 2.46% 64.98% 20.41% 3.81% 3.76% .RUT 25.90% 1.96% 28.57% 40.44% 1.33% 1.80% MO 25.68% 5.59% 14.62% 35.64% 11.59% 6.89% .VIX 0.00% 0.00% 100.00% 0.00% 0.00% 0.00% GE 2.89% 5.60% 15.66% 52.26% 12.27% 11.32 Can I use the Conditional Format to highlight the rows were the value in ColB is less than 3% and any other value in the row is greater than 50% ? Thank you in advance. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formating
carl wrote:
<snip My data table looks like this A B C D E F QQQQ 8.52% 3.31% 20.65% 33.18% 16.11% 18.23% AAPL 3.04% 4.59% 24.84% 27.91% 18.27% 21.35% SPY 4.34% 5.00% 47.32% 19.28% 4.37% 19.70% .SPX 0.00% 0.00% 100.00% 0.00% 0.00% 0.00% IWM 3.49% 2.33% 22.51% 16.43% 50.38% 4.87% XLF 5.21% 1.10% 14.86% 53.95% 23.33% 1.55% AMGN 4.59% 2.46% 64.98% 20.41% 3.81% 3.76% .RUT 25.90% 1.96% 28.57% 40.44% 1.33% 1.80% MO 25.68% 5.59% 14.62% 35.64% 11.59% 6.89% .VIX 0.00% 0.00% 100.00% 0.00% 0.00% 0.00% GE 2.89% 5.60% 15.66% 52.26% 12.27% 11.32 Can I use the Conditional Format to highlight the rows were the value in ColB is less than 3% and any other value in the row is greater than 50% ? Thank you in advance. Highlight your data. I'm going to assume your column B is in Excel column C Conditional format Formula is =AND($D2=0.03,MAX($C2:$H2)=0.5) Format as desired Doe this work for you? Beege |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formating
carl wrote:
Thanks. This does not work. I probably did not explain my problem well enough. I need the Conditional Format to highlight only the rows were the value in ColB is less than 3% and any other value in the row is greater than 50% ? Seems like it would be an IF/AND problem ? Any thoughts ? "Darrilyn" wrote: Yes you can. Highlight all of the data and on condition one you will choose formula is and type in =$B2<3 and then click add and on condition two you will click cell value is and choose greater than or equal too or just greater than and a drop down box will appear and click the value that you want. Choose your formatting from the format box and it should work. "carl" wrote: My data table looks like this A B C D E F QQQQ 8.52% 3.31% 20.65% 33.18% 16.11% 18.23% AAPL 3.04% 4.59% 24.84% 27.91% 18.27% 21.35% SPY 4.34% 5.00% 47.32% 19.28% 4.37% 19.70% .SPX 0.00% 0.00% 100.00% 0.00% 0.00% 0.00% IWM 3.49% 2.33% 22.51% 16.43% 50.38% 4.87% XLF 5.21% 1.10% 14.86% 53.95% 23.33% 1.55% AMGN 4.59% 2.46% 64.98% 20.41% 3.81% 3.76% .RUT 25.90% 1.96% 28.57% 40.44% 1.33% 1.80% MO 25.68% 5.59% 14.62% 35.64% 11.59% 6.89% .VIX 0.00% 0.00% 100.00% 0.00% 0.00% 0.00% GE 2.89% 5.60% 15.66% 52.26% 12.27% 11.32 Can I use the Conditional Format to highlight the rows were the value in ColB is less than 3% and any other value in the row is greater than 50% ? Thank you in advance. If your column B is in excel column C and your date is from B2 to H12, then Try C/F Formula is =AND($C2=0.03,MAX($B2:$H2)=0.5) Format as desired. Helps? Beege |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formating | Excel Discussion (Misc queries) | |||
conditional formating?? | Excel Discussion (Misc queries) | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
Conditional formating | Excel Discussion (Misc queries) | |||
Conditional Formating | Excel Worksheet Functions |