Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Questions on using conditional formatting
I've got a spreadsheet that that has multiple colums of numbers. In each
colum I want to change the color of the cell based on the previous cell number for example. If A2 A1 i want the text to be green. If A2 < A1 the text should be red, and if A2 = A1 the text is black. I've been able to accomplish this, but is there an easy way to format the whole spreadsheet quickly, or will I have to do each cell one by one? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Questions on using conditional formatting
If you select the range first (like A2:X9999), then do format|conditional
formatting, you can write the formula using references for the activecell (a2). nathanwst wrote: I've got a spreadsheet that that has multiple colums of numbers. In each colum I want to change the color of the cell based on the previous cell number for example. If A2 A1 i want the text to be green. If A2 < A1 the text should be red, and if A2 = A1 the text is black. I've been able to accomplish this, but is there an easy way to format the whole spreadsheet quickly, or will I have to do each cell one by one? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Questions on using conditional formatting
1) Highlight the range of cells from A2:A1000 (or however far down you need
to go...resist the urge to select the whole column). Make sure A2 is the primary highlighted cell. 2) Open Cond. Formatting and enter this formula: Condition1: Formula Is: =$A2<$A1 Format... Font color: RED Condition2: Formula Is: =$A2$A1 Format... Font color: GREEN 3) Format the regular font color as BLACK By making sure there are no $ symbols in front of the row numbers, they will adjust themselves relatively down the entire highlighted range. -- "Actually, I *am* a rocket scientist." -- JB (www.MadRocketScientist.com) Your feedback is appreciated, click YES if this post helped you. "nathanwst" wrote: I've got a spreadsheet that that has multiple colums of numbers. In each colum I want to change the color of the cell based on the previous cell number for example. If A2 A1 i want the text to be green. If A2 < A1 the text should be red, and if A2 = A1 the text is black. I've been able to accomplish this, but is there an easy way to format the whole spreadsheet quickly, or will I have to do each cell one by one? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Questions | Excel Discussion (Misc queries) | |||
Formatting Questions | Excel Discussion (Misc queries) | |||
Conditional Format - Due Dates - 2 questions (2nd posting) | Excel Discussion (Misc queries) | |||
Conditional Format - Due Dates - 2 questions | Excel Discussion (Misc queries) | |||
Three questions on hyperlinking and conditional formatting | Excel Worksheet Functions |