| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I use an if statement within the conditional formatting tool?
I am wanting to say if column A = and column b is <95% highlight column B.
Is this feasable? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I use an if statement within the conditional formatting tool?
I'm not sure what your A should equal.
Use this formula in your conditional formatting line. Change dropdown to "Formula Is". =AND(A1=25,B1.95) Note: In my example, 25 is the first condition for A =. Adjust as necessary. HTH, Paul "Jen" wrote in message ... I am wanting to say if column A = and column b is <95% highlight column B. Is this feasable? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I use an if statement within the conditional formatting tool?
You can but it's not necessary:
I am wanting to say if column A = and column b is <95% highlight column B. Do you mean if column A = 95% and column B < 95% ? =AND(A1=0.95,ISNUMBER(B1),B1<0.95) Biff "Jen" wrote in message ... I am wanting to say if column A = and column b is <95% highlight column B. Is this feasable? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting...cont. from 9/25 | Excel Discussion (Misc queries) | |||
| Conditional Formatting Cell < Today() | Excel Worksheet Functions | |||
| difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
| conditional formatting conflict? | Excel Worksheet Functions | |||
| Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
