| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell color
Hi.
I have a spreadsheet with about 7000 rows. To make this readable I would like to add some conditional formating but I just cant seem to get it right. example If A!=B change the cellcolor of A to red A B 1 1 1 2 3 5 3 2 2 4 4 1 Anyone got a clue? Thanks alot! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cell color
sry
what I mean is that I want to perform the check on every row, like this If A1!=B1 change the color If A2!=B2 change the color etc etc "ChrisP" skrev: Hi. I have a spreadsheet with about 7000 rows. To make this readable I would like to add some conditional formating but I just cant seem to get it right. example If A!=B change the cellcolor of A to red A B 1 1 1 2 3 5 3 2 2 4 4 1 Anyone got a clue? Thanks alot! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cell color
sorry i can not underestand A1! what does "!" mean is it a type mistake?
Thanks, -- Farhad Hodjat "ChrisP" wrote: sry what I mean is that I want to perform the check on every row, like this If A1!=B1 change the color If A2!=B2 change the color etc etc "ChrisP" skrev: Hi. I have a spreadsheet with about 7000 rows. To make this readable I would like to add some conditional formating but I just cant seem to get it right. example If A!=B change the cellcolor of A to red A B 1 1 1 2 3 5 3 2 2 4 4 1 Anyone got a clue? Thanks alot! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cell color
Hi Chris
Mark the range A1:B7000 FormatConditional Formattinguse dropdown for Formula Is =A1=B1 Choose Format required Note that in the formula pane it is essential to enter the starting = -- Regards Roger Govier "ChrisP" wrote in message ... sry what I mean is that I want to perform the check on every row, like this If A1!=B1 change the color If A2!=B2 change the color etc etc "ChrisP" skrev: Hi. I have a spreadsheet with about 7000 rows. To make this readable I would like to add some conditional formating but I just cant seem to get it right. example If A!=B change the cellcolor of A to red A B 1 1 1 2 3 5 3 2 2 4 4 1 Anyone got a clue? Thanks alot! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cell color
hmm doesnt seem to do the right comparison.
It does highlight cells, but not like the code specifies. It looks like the hightlight are totaly random. Any other ideas? Im all out :( Btw != is the same as NOT() "Roger Govier" skrev: Hi Chris Mark the range A1:B7000 FormatConditional Formattinguse dropdown for Formula Is =A1=B1 Choose Format required Note that in the formula pane it is essential to enter the starting = -- Regards Roger Govier "ChrisP" wrote in message ... sry what I mean is that I want to perform the check on every row, like this If A1!=B1 change the color If A2!=B2 change the color etc etc "ChrisP" skrev: Hi. I have a spreadsheet with about 7000 rows. To make this readable I would like to add some conditional formating but I just cant seem to get it right. example If A!=B change the cellcolor of A to red A B 1 1 1 2 3 5 3 2 2 4 4 1 Anyone got a clue? Thanks alot! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cell color
Hi,
The right formula is: =AND(B2,NOT(ISBLANK(B2))) to avoid changing the color when the cells are blank. Thanks, -- Farhad Hodjat "Roger Govier" wrote: Hi Chris Mark the range A1:B7000 FormatConditional Formattinguse dropdown for Formula Is =A1=B1 Choose Format required Note that in the formula pane it is essential to enter the starting = -- Regards Roger Govier "ChrisP" wrote in message ... sry what I mean is that I want to perform the check on every row, like this If A1!=B1 change the color If A2!=B2 change the color etc etc "ChrisP" skrev: Hi. I have a spreadsheet with about 7000 rows. To make this readable I would like to add some conditional formating but I just cant seem to get it right. example If A!=B change the cellcolor of A to red A B 1 1 1 2 3 5 3 2 2 4 4 1 Anyone got a clue? Thanks alot! |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cell color
So if you want highlight cell A2 if it is not equal to B2 then you have to do
this: active cell A2 go to menu: formatconditional formatting and then the first combobox should be "cell value is:" and the second combobox sould be "not equal to" and in the text box enter =B2 then click OK you can copy the format of the cell B2 to any other cells that you need Thanks, -- Farhad Hodjat "ChrisP" wrote: hmm doesnt seem to do the right comparison. It does highlight cells, but not like the code specifies. It looks like the hightlight are totaly random. Any other ideas? Im all out :( Btw != is the same as NOT() "Roger Govier" skrev: Hi Chris Mark the range A1:B7000 FormatConditional Formattinguse dropdown for Formula Is =A1=B1 Choose Format required Note that in the formula pane it is essential to enter the starting = -- Regards Roger Govier "ChrisP" wrote in message ... sry what I mean is that I want to perform the check on every row, like this If A1!=B1 change the color If A2!=B2 change the color etc etc "ChrisP" skrev: Hi. I have a spreadsheet with about 7000 rows. To make this readable I would like to add some conditional formating but I just cant seem to get it right. example If A!=B change the cellcolor of A to red A B 1 1 1 2 3 5 3 2 2 4 4 1 Anyone got a clue? Thanks alot! |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cell color
I think you meant the formula to be
=AND(A2<B2,NOT(ISBLANK(B2))) Why not Choose entire column(s) If you want to color both cells or the entire row you can change the formula to =AND($A2<$B2,NOT(ISBLANK($B2) --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Farhad" wrote in message ... Hi, The right formula is: =AND(B2,NOT(ISBLANK(B2))) to avoid changing the color when the cells are blank. Thanks, -- Farhad Hodjat "Roger Govier" wrote: Hi Chris Mark the range A1:B7000 FormatConditional Formattinguse dropdown for Formula Is =A1=B1 Choose Format required Note that in the formula pane it is essential to enter the starting = -- Regards Roger Govier "ChrisP" wrote in message ... sry what I mean is that I want to perform the check on every row, like this If A1!=B1 change the color If A2!=B2 change the color etc etc "ChrisP" skrev: Hi. I have a spreadsheet with about 7000 rows. To make this readable I would like to add some conditional formating but I just cant seem to get it right. example If A!=B change the cellcolor of A to red A B 1 1 1 2 3 5 3 2 2 4 4 1 Anyone got a clue? Thanks alot! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't format cell color/text color in Office Excel 2003 in fil | Excel Discussion (Misc queries) | |||
| Excel: Syntax to change cell color based on color of another cell | Excel Worksheet Functions | |||
| Can't format cell color/text color in Office Excel 2003 in files . | Excel Discussion (Misc queries) | |||
| How to change the default Border, Font Color, and Cell Color | Excel Discussion (Misc queries) | |||
| Default Border, Font Color, and Cell Background Color | Excel Discussion (Misc queries) | |||
Linear Mode
