| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting confusion - Excel 2003
I am trying to apply a conditional format to a cell when either/both of two
other cells on the row contain a value. I have tried every permutation I can think of but nothing is working. I'm pasting a couple of variants of what I've tried. (I also tried zero in the place of the one.) Can anyone advise what I am doing wrong? Thanks! =((W4+AF4)1) =((W4+AF4)"1") =IF((W4+AF4)1,TRUE,FALSE) =IF((W4+AF4)"1",TRUE,FALSE) -- Ann Scharpf |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting Confusion | Excel Worksheet Functions | |||
| SUMIF() confusion (Excel 2003) | Excel Worksheet Functions | |||
| Conditional formatting confusion | Excel Worksheet Functions | |||
| Confusion...(conditional formatting) | New Users to Excel | |||
| Validation Confusion-Excel 2003 | Excel Discussion (Misc queries) | |||
Threaded Mode
