Microsoft Excel - Conditional Formatting
Asked By Daron Shiflet
20-Nov-09 12:29 PM
I'm using Excel 2007 and I want to shade values in column AB if they are less than values in column W in their corresponding rows. I can do this with Conditional Formatting of course, but I would have to do this with each individual cell. How can I get around this?
Please help!
Thanks...
Jonathan VH replied to Daron Shiflet
Add the conditional formatting you want to just one cell in the AB column. Make sure you use a relative reference (no $) for at least the row numbers in the range references in your formula, e.g.:
Formula is =AB1<W1
and create the format (Patterns color).
Then Copy that cell, and Paste Special, Formats to the other cells in column AB.
Matthew Johnson replied to Daron Shiflet
If you set the first cell with the c.f that you want, you can then use the format painter (double-clicked) and then click on the column header AB. That should take care of it. Just make sure that the rule leaves off the $ on the row number.
Worked Perfectly
Thanks a million...now I feel like an idiot because I thought I tried that, only problem was I was pasting formulas instead of formats...whoops!
conditional formatting excel Excel I would appreciate some links on learning more about formulaes for conditional formatting - I find it very interesting and would like to know a wide range of things that it can do. thanks. S Excel Discussions Microsoft Excel (1) Excel (1) VBA (1) Devenshire (1) Formulaes (1) Constants (1) Bliengme (1) Hundreds (1) Try: http
Alert in Microsoft Excel Excel Hello, helpful people. I am not very familiar with Excel 2007, but I am gradually trying to become familiar. I will try to be clear not been completed by its due date. I appreciate any help you guys can give! Excel Worksheet Discussions Microsoft Excel (1) Excel 2007 (1) Eyesight (1) Equals (1) Guys (1) Use Conditional Formmating. Select your date cells
Can I use AVERAGEIFS? Excel Excel Worksheet Discussions Microsoft Excel (1) Excel 2007 (1) Excel (1) ISNUMBER (1) AVERAGE (1) TEXT (1) Debug.Print (1) October (1) Try (in 2007 Enter. AVERAGE will automatically ignore cells with text strings. But if D3 is actually the Excel error #NA instead of the string "NA", you will need another term to ignore it this application. AND returns a single result where you need an array of results. - - Biff Microsoft Excel MVP Perhaps you could use: = 3DSUMIFS( . . . ) / COUNTIFS( . . . ) with the same conditional parameters in the
Conditional Formatting Excel Excel 2003 Can't select multiple worksheets at same time and use the conditional formatting tool. Is there a simple way of copying the conditional formatting to the other worksheets? Besides the format painter option. Excel Miscellaneous Discussions Microsoft Excel (1) Excel 2003 (1) Nadine (1) Goto (1) D49A64A56534 (1) Painter (1) Hinot (1) hi
Need help with creating a due date formula in excel Microsoft Excel Hi all, I'm creating an Excel spreadsheet and in Column C I have entered in the date an issue was opened displays correctly. formula for column e = workday(c1, 60) You can change the colors using conditional formatting. Keep the cursor in cell d1. Choose format / Conditional formatting Choose cell value - is equal to - in the third dropdown type = today(). Then click will prevent the ugly #NUM! error when no data is entered Hi, Here is an Excel worksheet with all of the scheduled tasks that have to be completed at a department the formula down by double-clicking the fill handle. 4. Cool Trick: Set up a Conditional Format that will use three colors: • Tasks Due today in Green • Tasks Due tomorrow in