Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting based on the value of another cell
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) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting based on the value of another cell
You need to use the CF/ Formula Is ... option, rather than CF/ Cell Value Is
.... then you can use Formula Is =M5<0 -- David Biddulph "bwilde" wrote in message ... 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) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting based on the value of another cell
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) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting based on the value of another cell
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) . |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting based on the value of another cell
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) . |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting based on the value of another cell
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) . . |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting based on the value of another cell
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) . . |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting based on the value of another cell
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) . . . |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting based on the value of another cell
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) |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting based on the value of another cell
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) . |
#11
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 |