| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I copy a format that.........
I have a format set for cell (b2). this format analyzes the value of cell
(a2). If the value of (a2)and(b2)are equal then the text shows in green. If not, the text shows in red. Ok....YAY.... Now how do I go about formating an entire column(b) to do this with column(a)? Sounds stupid but everytime I try using the format painter then (b3) for example still analyzes (a2) rather then analyzing (a3). |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I copy a format that.........
Just out of curiosity, have you tried using conditional formatting?
"markythesk8erboi" wrote: I have a format set for cell (b2). this format analyzes the value of cell (a2). If the value of (a2)and(b2)are equal then the text shows in green. If not, the text shows in red. Ok....YAY.... Now how do I go about formating an entire column(b) to do this with column(a)? Sounds stupid but everytime I try using the format painter then (b3) for example still analyzes (a2) rather then analyzing (a3). |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I copy a format that.........
Yes I have. Same problem. It only analyzes the first cell. What I want it to
do is analyze the cell directly to the left of it wherever it is. So I understand how to get it to do this with (b2) analyzing (A2). but then B3, b4, b5,..... ALL analyze (a2) rather then analyzing A3, a4, a5,.............. "A Need to Excel" wrote: Just out of curiosity, have you tried using conditional formatting? "markythesk8erboi" wrote: I have a format set for cell (b2). this format analyzes the value of cell (a2). If the value of (a2)and(b2)are equal then the text shows in green. If not, the text shows in red. Ok....YAY.... Now how do I go about formating an entire column(b) to do this with column(a)? Sounds stupid but everytime I try using the format painter then (b3) for example still analyzes (a2) rather then analyzing (a3). |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I copy a format that.........
What formula are you using?
Are you including "$" in the cell reference? "markythesk8erboi" wrote: Yes I have. Same problem. It only analyzes the first cell. What I want it to do is analyze the cell directly to the left of it wherever it is. So I understand how to get it to do this with (b2) analyzing (A2). but then B3, b4, b5,..... ALL analyze (a2) rather then analyzing A3, a4, a5,.............. "A Need to Excel" wrote: Just out of curiosity, have you tried using conditional formatting? "markythesk8erboi" wrote: I have a format set for cell (b2). this format analyzes the value of cell (a2). If the value of (a2)and(b2)are equal then the text shows in green. If not, the text shows in red. Ok....YAY.... Now how do I go about formating an entire column(b) to do this with column(a)? Sounds stupid but everytime I try using the format painter then (b3) for example still analyzes (a2) rather then analyzing (a3). |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I copy a format that.........
cell value, is equal to =$G$2
cell value, is not equal to =$G$2 "A Need to Excel" wrote: What formula are you using? Are you including "$" in the cell reference? "markythesk8erboi" wrote: Yes I have. Same problem. It only analyzes the first cell. What I want it to do is analyze the cell directly to the left of it wherever it is. So I understand how to get it to do this with (b2) analyzing (A2). but then B3, b4, b5,..... ALL analyze (a2) rather then analyzing A3, a4, a5,.............. "A Need to Excel" wrote: Just out of curiosity, have you tried using conditional formatting? "markythesk8erboi" wrote: I have a format set for cell (b2). this format analyzes the value of cell (a2). If the value of (a2)and(b2)are equal then the text shows in green. If not, the text shows in red. Ok....YAY.... Now how do I go about formating an entire column(b) to do this with column(a)? Sounds stupid but everytime I try using the format painter then (b3) for example still analyzes (a2) rather then analyzing (a3). |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I copy a format that.........
If you want to apply the format downwards, don't use $2 - just put 2.
If you want to apply the CF across the sheet on adjacent columns, don't use $G. In your first post you talked about columns A and B, so this is a bit confused. Hope this helps. Pete On Nov 13, 9:48 pm, markythesk8erboi wrote: cell value, is equal to =$G$2 cell value, is not equal to =$G$2 "A Need to Excel" wrote: What formula are you using? Are you including "$" in the cell reference? "markythesk8erboi" wrote: Yes I have. Same problem. It only analyzes the first cell. What I want it to do is analyze the cell directly to the left of it wherever it is. So I understand how to get it to do this with (b2) analyzing (A2). but then B3, b4, b5,..... ALL analyze (a2) rather then analyzing A3, a4, a5,.............. "A Need to Excel" wrote: Just out of curiosity, have you tried using conditional formatting? "markythesk8erboi" wrote: I have a format set for cell (b2). this format analyzes the value of cell (a2). If the value of (a2)and(b2)are equal then the text shows in green. If not, the text shows in red. Ok....YAY.... Now how do I go about formating an entire column(b) to do this with column(a)? Sounds stupid but everytime I try using the format painter then (b3) for example still analyzes (a2) rather then analyzing (a3).- Hide quoted text - - Show quoted text - |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I copy a format that.........
Yeah, that's it -- The $ tells it to keep looking in the same spot. Try it
without it, and see what happens. "markythesk8erboi" wrote: cell value, is equal to =$G$2 cell value, is not equal to =$G$2 "A Need to Excel" wrote: What formula are you using? Are you including "$" in the cell reference? "markythesk8erboi" wrote: Yes I have. Same problem. It only analyzes the first cell. What I want it to do is analyze the cell directly to the left of it wherever it is. So I understand how to get it to do this with (b2) analyzing (A2). but then B3, b4, b5,..... ALL analyze (a2) rather then analyzing A3, a4, a5,.............. "A Need to Excel" wrote: Just out of curiosity, have you tried using conditional formatting? "markythesk8erboi" wrote: I have a format set for cell (b2). this format analyzes the value of cell (a2). If the value of (a2)and(b2)are equal then the text shows in green. If not, the text shows in red. Ok....YAY.... Now how do I go about formating an entire column(b) to do this with column(a)? Sounds stupid but everytime I try using the format painter then (b3) for example still analyzes (a2) rather then analyzing (a3). |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
| copy with format | New Users to Excel | |||
| How do I copy data in single cell format to a merged cell format | Excel Discussion (Misc queries) | |||
| copy conditional format to regular format | Setting up and Configuration of Excel | |||
| copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
Linear Mode
