Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Boolean formula for Conditional Formatting
I'd like cell D5 to turn red if it is a negative value and cell C5 has a
value of 9. How do I set this up? I've tried entering a boolean formula such as ... +d5<0 #and# +c5=9 But Excel doesn't seem to recognize #and#. I tried entering the second part of the formula as a second condition, but that seems to be if you want the cell format to have multiple possible outcomes. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Boolean formula for Conditional Formatting
Arthur,
Try a formula like =AND(D5<0,C5=9) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Arthur" wrote in message ... I'd like cell D5 to turn red if it is a negative value and cell C5 has a value of 9. How do I set this up? I've tried entering a boolean formula such as ... +d5<0 #and# +c5=9 But Excel doesn't seem to recognize #and#. I tried entering the second part of the formula as a second condition, but that seems to be if you want the cell format to have multiple possible outcomes. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Boolean formula for Conditional Formatting
I found the answer in an 8/25 post:
and(condition1,condition2) "Arthur" wrote: I'd like cell D5 to turn red if it is a negative value and cell C5 has a value of 9. How do I set this up? I've tried entering a boolean formula such as ... +d5<0 #and# +c5=9 But Excel doesn't seem to recognize #and#. I tried entering the second part of the formula as a second condition, but that seems to be if you want the cell format to have multiple possible outcomes. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need help with a formula or conditional formatting | Excel Worksheet Functions | |||
%formula in conditional formatting | Excel Worksheet Functions | |||
Conditional formatting is set with a formula, but now I need to ch | Excel Discussion (Misc queries) | |||
In Excel, can Boolean logic be applied to conditional formatting? | Excel Worksheet Functions | |||
conditional formatting formula | Excel Programming |