Using AND OR in an IF statement (Help)

October 5, 2010 at 07:10:24
Specs: Windows XP

Sorry if I do not explain this well....

I am completing some spreadsheets and would like to highlight variances which are more that +or-5% and greater than +or- £500.

I have managed to do this using the following: (this may not be the easiest way but is working)


However this will only bring back TRUE or FALSE, I would like to have an option as to what the true or false value is. As I would in an IF statement.

I have tried to combine the above with an IF statement but this has not worked.

Any advice would be much appreciated

See More: Using AND OR in an IF statement (Help)

Report •

October 5, 2010 at 13:58:18
Not sure I understand your problem.

If you want to highlight variances then are you using Conditional Formatting?
If you are, then Conditional Formatting triggers on True or False.


Report •

October 6, 2010 at 03:09:56

I wasn't using conditional formatting, but did realise last night that I should be. I just need to remember how to do this now.

Report •

October 6, 2010 at 07:34:40
If your using 2007:

To do Conditional Formatting:

1) Select your cell
2) Under the Home Tab, on the ribbon click Conditional Formatting
3) Click on New Rules, it’s near the bottom of the dialog box.
4) Click Use Formula to determine which cells to format.
5) Enter formula
6) Click on the Format button
7) Select the Fill Tab
8) Select color
9) Click OK

For additional conditions, there is an add button.

For 2003 & 2000

On the Menu Bar:
1) Select Format
2) Select Conditional Formatting
3) Change “Cell Value is” to “Formula Is”
4) Enter the formula
5) Click on the Format button
6) Select Patterns
7) Select color
8) Click OK


Report •
Related Solutions

Ask Question