| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula in Conditional Formatting
I'm trying to set up a conditional format in my spreadsheet that allows me to
say if cell A1A2 and A3A2 then do this, but it won't allow to create this formula. Can I set this up or is there no way to accomplish this? Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula in Conditional Formatting
Hi,
This should work as a CF formula =AND(A1A2,A3A2) Mike "TJAC" wrote: I'm trying to set up a conditional format in my spreadsheet that allows me to say if cell A1A2 and A3A2 then do this, but it won't allow to create this formula. Can I set this up or is there no way to accomplish this? Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula in Conditional Formatting
FormatCFFormula is: =AND(A2A1,(A3A2))
Gord Dibben MS Excel MVP On Wed, 10 Sep 2008 06:29:01 -0700, TJAC wrote: I'm trying to set up a conditional format in my spreadsheet that allows me to say if cell A1A2 and A3A2 then do this, but it won't allow to create this formula. Can I set this up or is there no way to accomplish this? Thanks! |
| 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 formula | Excel Discussion (Misc queries) | |||
| conditional formatting with formula | Excel Worksheet Functions | |||
| Conditional Formatting Formula | New Users to Excel | |||
Linear Mode
