Conditional Format Feature

C

carl

Is it possible to have the conditional format feature to flag a row if the
following conditions exists:

A1<1, B1>5, C1<>#N/A

Thank you in advance.
 
V

Vic Sowers

carl said:
Is it possible to have the conditional format feature to flag a row if the
following conditions exists:

A1<1, B1>5, C1<>#N/A

Thank you in advance.
Click to expand...

Select the row and open the Conditional Formatting dialog box
In the drop down box choose 'Formula is'
In the formula entry area put: '=(A1<1)*(B1>5)*NOT(ISNA(C1))=1'
 
C

carl

thank you duke.

i ran into another scenario and wondered if the conditional formating can
help me identify it:

IF A1-B1<0 and C1<>#N/A do format condition 1 but if A1-B1>0 and C1<>#N/A,
do format condition 2.

Is this possible to do with the excel conditional formating ??
 
D

Duke Carey

At the bottom of the conditional formatting dialog there's an Add>> button
that allows you to put in a second condition & a different format

You'd simply want the first one to be
=AND(B1>A1,NOT(ISNA(C1)))

and the second one would be
=AND(B1<A1,NOT(ISNA(C1)))

QUESTION: what do you want to do if A1=B1?
 
C

carl

Thank you again. Yes, I need to consider if there the values in A and B are
the same. B I am learning how to use the condtional formating feature to help
me identify problems. In trying to refine my original question, is it
possible to do the following (I have figured out how to color the cells -
just not sure how to contruct the conditrions:

Trying to flag changes greater than -5% Red, changes greater than 5% Blue,
but not flag if the value in C is 0 (zero) or #N/A.

Change
A 0% 25.00% -25% Flag Red
B 0% 0.00% 0% No Flag
C 22% 25.00% -3% No Flag
D 27% 25.00% 2% No Flag
E 35% 25.00% 10% Flag Blue
F 45% 25.00% 20% Flag Blue

Thank you agian. I appreciate your instruction.
 
Top