Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting in Excel 2007
This was easy to do in earlier versions of Excel but I cannot find how to do
it in Excel 2007. I have around 50 columns of data with several hundred values in each column. At the bottom of each column (always in the 524th row) I have a "threshold value". The threshold value is different for each column. I want to highlight values in the column that are above the threshold value for that column. This is easy to do for one column at a time, but using the format paintbrush does not copy the appropriate formula, even if I take care to make the comparison cell partially relative (e.g., A$524 rather than $A$524). Can anybody help? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving Conditional Formatting in Excel 2007 | Excel Discussion (Misc queries) | |||
Conditional Formatting: Excel 2003 vs. 2007 | Excel Worksheet Functions | |||
Excel 2007 beta 2 - Conditional Formatting Suggestion | Excel Discussion (Misc queries) | |||
Excel 2007 Conditional Formatting barely works | Excel Discussion (Misc queries) | |||
Conditional Formatting in Excel 2007 | Excel Discussion (Misc queries) |