Conditional Formatting with Formulas - PLEASE HELP

[bacardi510]

Hi, thank you for your help! I am trying to use conditional formatting to change to fill of cell based on a formula that analyzes other cells. I have data in cell "u" and "bb". I need the formatting to effect all of column BB (this cell contains a number, not a percentage). For example my first row would be, IF (BB2+U2)/U2 is greater than or equal to 110% then change the fill to RED But If (BB2+U2)/U2 is less than or equal to 90% change the fill to blue. I cannot figure out the formula to use in conditional formatting. PLEASE HELP ME!

[FDibbins]

1st, pick a color and use regular formatting to make all cells that color (say, Blue).
then
1. highlight the range you want to apply the conditional formatting to
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =(BB2+U2)/U2>=1.1 format fill RED

[bacardi510]

Thank you, I need it to apply to the whole column of BB not just BB2. How would I do that?

[samba_ravi]

Use the following in formulas in conditional formats

=BB2/U2>=0.1
=BB2/U2<=-0.1

[bacardi510]

conditional formatting example.xlsx

Here is an example of what I am trying to do. The problem I am having is trying to have the conditional formatting for all of column BB and getting it correct.

[FDibbins]

I would caution against using an entire column, use only the range you need. CF is resource-heavy and can tend to slow things down.

I covered selecting the range in point 1 above

@ Siva, if there are only 2 colors, you can use regular formatting for 1 color, then you only need 1 CF rule for the other color Saving a CF rule

[samba_ravi]

I would caution against using an entire column, use only the range you need. CF is resource-heavy and can tend to slow things down.

I covered selecting the range in point 1 above

@ Siva, if there are only 2 colors, you can use regular formatting for 1 color, then you only need 1 CF rule for the other color Saving a CF rule

FDibbins you are right, but op is asked for
IF (BB2+U2)/U2 is greater than or equal to 110% then change the fill to RED
If (BB2+U2)/U2 is less than or equal to 90% change the fill to blue

so that between 90% to 110% the original format remains

[bacardi510]

conditional formatting example.xlsx
I appreciate your help and quick response. I have attached an example of what I am trying to accomplish. I have a range with no color 90% - 110% so formatting the color will not work for me. Please see the attached workbook.

[samba_ravi]

see the attached file