Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Color Me Red
A B
Range Average 200.0 46.0 500.0 120.0 3900.0 1733.0 950.0 485.0 3000 3317.0 4.8 4.0 2.0 1.2 136.0 87.1 40.0 17.2 need some way to color column B red, if greater than column A I tried to conditional format but when I copy down it don't work There are actually 63 rows and 43 columns. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Color Me Red
Try highlighting all the Cells in Column B then perform your conditional
formating again. You can not copy and paste this function. -- tech1NJ "Yrrep" wrote: A B Range Average 200.0 46.0 500.0 120.0 3900.0 1733.0 950.0 485.0 3000 3317.0 4.8 4.0 2.0 1.2 136.0 87.1 40.0 17.2 need some way to color column B red, if greater than column A I tried to conditional format but when I copy down it don't work There are actually 63 rows and 43 columns. . |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Color Me Red
When I try to select all of column B and CF then "greater than", then select
all column A, then color red I get "cannot use direct reference to a worksheet range in a conditional format formula." "tech1NJ" wrote in message ... Try highlighting all the Cells in Column B then perform your conditional formating again. You can not copy and paste this function. -- tech1NJ "Yrrep" wrote: A B Range Average 200.0 46.0 500.0 120.0 3900.0 1733.0 950.0 485.0 3000 3317.0 4.8 4.0 2.0 1.2 136.0 87.1 40.0 17.2 need some way to color column B red, if greater than column A I tried to conditional format but when I copy down it don't work There are actually 63 rows and 43 columns. . |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Color Me Red
Put your cursor in cell B2 and go to Conditional Formatting. Choose greater
than and then select cell A2 as the one to compare to. Then select Format and choose the Pattern red. If you look at the box to the right of the greater than option you'll see it reads =$A$2. Remove the dollar sign before the 2 and hit OK. Then copy this cell all the way down to the end of the data you are formatting. "Yrrep" wrote: When I try to select all of column B and CF then "greater than", then select all column A, then color red I get "cannot use direct reference to a worksheet range in a conditional format formula." "tech1NJ" wrote in message ... Try highlighting all the Cells in Column B then perform your conditional formating again. You can not copy and paste this function. -- tech1NJ "Yrrep" wrote: A B Range Average 200.0 46.0 500.0 120.0 3900.0 1733.0 950.0 485.0 3000 3317.0 4.8 4.0 2.0 1.2 136.0 87.1 40.0 17.2 need some way to color column B red, if greater than column A I tried to conditional format but when I copy down it don't work There are actually 63 rows and 43 columns. . . |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Color Me Red
Apply the conditional formatting. Then go back into that cell and look at
the formula to the right of the "greater than" option. It will look something like: =$A$2. Remove the "$" before the 2. Now you can paste it all the way down. "Yrrep" wrote: When I try to select all of column B and CF then "greater than", then select all column A, then color red I get "cannot use direct reference to a worksheet range in a conditional format formula." "tech1NJ" wrote in message ... Try highlighting all the Cells in Column B then perform your conditional formating again. You can not copy and paste this function. -- tech1NJ "Yrrep" wrote: A B Range Average 200.0 46.0 500.0 120.0 3900.0 1733.0 950.0 485.0 3000 3317.0 4.8 4.0 2.0 1.2 136.0 87.1 40.0 17.2 need some way to color column B red, if greater than column A I tried to conditional format but when I copy down it don't work There are actually 63 rows and 43 columns. . . |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Color Me Red
Assuming that your number start at A2 to A4 and B2 to B4 try this
Highlight B2 to B4, then go to conditional formatting and select "Cell is", "Equal greaterthan", Select A2 to A4 then choose your format (red). -- tech1NJ "Yrrep" wrote: When I try to select all of column B and CF then "greater than", then select all column A, then color red I get "cannot use direct reference to a worksheet range in a conditional format formula." "tech1NJ" wrote in message ... Try highlighting all the Cells in Column B then perform your conditional formating again. You can not copy and paste this function. -- tech1NJ "Yrrep" wrote: A B Range Average 200.0 46.0 500.0 120.0 3900.0 1733.0 950.0 485.0 3000 3317.0 4.8 4.0 2.0 1.2 136.0 87.1 40.0 17.2 need some way to color column B red, if greater than column A I tried to conditional format but when I copy down it don't work There are actually 63 rows and 43 columns. . . |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Color Me Red
thanks tech1 NJ from yrrep also in NJ
when I do what you suggest I get the following error message cannot use direct reference to a worksheet range in a conditional format formula Change reference to a single cell, or use reference with a worksheet function as =sum(a1:e5) the only way I can get it to work is to do each row one at a time, that 84 times thanks Microsoft "tech1NJ" wrote in message ... Assuming that your number start at A2 to A4 and B2 to B4 try this Highlight B2 to B4, then go to conditional formatting and select "Cell is", "Equal greaterthan", Select A2 to A4 then choose your format (red). -- tech1NJ "Yrrep" wrote: When I try to select all of column B and CF then "greater than", then select all column A, then color red I get "cannot use direct reference to a worksheet range in a conditional format formula." "tech1NJ" wrote in message ... Try highlighting all the Cells in Column B then perform your conditional formating again. You can not copy and paste this function. -- tech1NJ "Yrrep" wrote: A B Range Average 200.0 46.0 500.0 120.0 3900.0 1733.0 950.0 485.0 3000 3317.0 4.8 4.0 2.0 1.2 136.0 87.1 40.0 17.2 need some way to color column B red, if greater than column A I tried to conditional format but when I copy down it don't work There are actually 63 rows and 43 columns. . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Powerpoint / Excel: custom pp RGB color doesn't match identical Excelcustom RGB color | Charts and Charting in Excel | |||
Can't format cell color/text color in Office Excel 2003 in fil | Excel Discussion (Misc queries) | |||
Can't format cell color/text color in Office Excel 2003 in files . | Excel Discussion (Misc queries) | |||
My fill color and font color do not work in Excel Std Edition 2003 | Excel Discussion (Misc queries) | |||
My excel 2003 wont let me fill cells with color or color the tabs. | New Users to Excel |