| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting based on the value of another cell
Glad to hear it.
-- David Biddulph "bwilde" wrote in message ... the excel help wasn't as helpful as you! =OR(M31<0,R31<0,X31<0) works thank you so much. "David Biddulph" wrote: In that case you need to look again at the Excel help for the OR function. It tells you that the syntax is OR(logical1,logical2,...) and gives examples such as =OR(1+1=1,2+2=5) It doesn't say =logical1 OR =logical2 -- David Biddulph bwilde wrote: If I put = M22<0 OR =R22<0 OR =X22<0 I get an error. If I put (= M22<0) OR (=R22<0) OR(=X22<0) it changes it to ='(= M22<0) OR (=R22<0) OR(=X22<0)' and there's no error but it doesn't work. "David Biddulph" wrote: Show us the formula you have used in your CF/ Formula Is condition, then we can tell you what you've got wrong. -- David Biddulph bwilde wrote: I did and I still can't seem to get it right. when i use OR either I get an error or if I don't get and error the CF doesn't work "David Biddulph" wrote: Perhaps you haven't looked at the Excel help for the OR function? That will tell you the syntax of the function. -- David Biddulph "bwilde" wrote in message ... thank you - would you also know how I can have more than one condition - I want to say if m22<=0 OR r22<=0 OR x22<=0 format green - I'm doing something wrong "Gord Dibben" wrote: Select A5 and CFFormula is: =M5<0 Gord Dibben MS Excel MVP On Mon, 11 Jan 2010 08:12:02 -0800, bwilde wrote: I want to apply a conditional format to a cell based on the value of another cell having nothing to do with the value of the cell I want the format to effect. for example - if the value in cell m5<0 i want cell a5 to be italic (regardless of the value in a5) . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting, based on a different cell? | Excel Discussion (Misc queries) | |||
| conditional Formatting based on a value in another cell | Excel Worksheet Functions | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| Conditional Formatting on one cell based on value in another | Excel Worksheet Functions | |||
![David Biddulph[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
