Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
AND and OR in Conditional Formatting
Can AND and OR be used in the formula of a conditional formatting?
Cell E3 contains a date. I have set the E3 conditional formatting as follows: CF1 formula is =+E3="" format cell with black font, white cell color CF2 formula is =E3<=TODAY() format cell with yellow font, red cell color CF3 formula is =E3TODAY() format cell with black font, green cell color I would like CF1 formula to be =+E3="" OR D3<"" format cell with black font, white cell color, but I get a syntax error message. Is there other syntax I should use, or is this not possible? TIA David R. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
AND and OR in Conditional Formatting
One way:
CF1: =OR(E3="",D3<"") Note that your "+" is superfluous in XL. It's a Lotus-ism. In article , Compass Rose wrote: Can AND and OR be used in the formula of a conditional formatting? Cell E3 contains a date. I have set the E3 conditional formatting as follows: CF1 formula is =+E3="" format cell with black font, white cell color CF2 formula is =E3<=TODAY() format cell with yellow font, red cell color CF3 formula is =E3TODAY() format cell with black font, green cell color I would like CF1 formula to be =+E3="" OR D3<"" format cell with black font, white cell color, but I get a syntax error message. Is there other syntax I should use, or is this not possible? TIA David R. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
AND and OR in Conditional Formatting
Quite simple
=OR(E3="",D3<"") AND is used in the same way. BTW, there is no need for a + in =+E3, =E3 is sufficient. -- HTH RP (remove nothere from the email address if mailing direct) "Compass Rose" wrote in message ... Can AND and OR be used in the formula of a conditional formatting? Cell E3 contains a date. I have set the E3 conditional formatting as follows: CF1 formula is =+E3="" format cell with black font, white cell color CF2 formula is =E3<=TODAY() format cell with yellow font, red cell color CF3 formula is =E3TODAY() format cell with black font, green cell color I would like CF1 formula to be =+E3="" OR D3<"" format cell with black font, white cell color, but I get a syntax error message. Is there other syntax I should use, or is this not possible? TIA David R. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I convert conditional formatting into explicit formatting? | Excel Discussion (Misc queries) | |||
Formatting Conditional Formatting Icon Sets | Excel Discussion (Misc queries) | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |