Excel Conditional Formating help

airbornflghtairbornflght Houston, TX Icrontian
edited April 2008 in Science & Tech
Does anyone know how to highlight a range of a row ex. (D3:G3) based on one value.

What I have is four columns. number of guests, cost, revenue, and profit.

What I want to do is highlight the row of the table where guests equals my calculated value in b8.

I'm pretty sure there is a way to do it with conditional formatting, but it will only highlight the one cell. I would like it to highlight a range of cells.

Comments

  • kryystkryyst Ontario, Canada
    edited April 2008
    Not sure if this would work the same in excel. But in Openoffice when you use the conditional format tool you can have it be conditional based on a formula. You then just have multiple conditions.

    So in Openoffice I simply do something like if A1>3 then set the condition to 'Red' where red is a style I've previously designed. Then setup another condition if B1>4 set the condition to 'Green'.

    You then would have to apply that conditioning to every cell you want to take the format. Conditional format still only works cell by cell, to make it work on a whole role you have to just keep applying the conditional format.

    There is also a formula in Openoffice you can add to the end of any formula that will apply a conditional format.

    So if your formula is =A1 then you change that formula to ==A1+STYLE(IF(CURRENT()>3;"Red";"Green")) Same rules apply you have to predefine what those styles are.
  • osaddictosaddict London, UK
    edited April 2008
    If you have Excel 2007 this is really quick... see attached file...

    Simply choose conditional formatting from the home tab

    (I think I might have mis understood your post though!)
  • KwitkoKwitko Sheriff of Banning (Retired) By the thing near the stuff Icrontian
    edited April 2008
    Copy that cell, highlight the ones you want to conditionally format, then Paste Special formatting.
  • airbornflghtairbornflght Houston, TX Icrontian
    edited April 2008
    Sounds like it would have worked kwitko, but I had to turn the project in so I just made it to where one row will always have the data I want highlighted and formated that row.
  • CBCB Ƹ̵̡Ӝ̵̨̄Ʒ Der Millionendorf- Icrontian
    edited April 2008
    I don't think it would have worked for you actually. From your OP, it sounds like you want to have the formatting of a whole row dependent upon the contents of a single cell. You can't do that. It's simply not how Conditional Formatting works in Excel.
  • MrBillMrBill Missouri Member
    edited April 2008
    CB Droege wrote:
    I don't think it would have worked for you actually. From your OP, it sounds like you want to have the formatting of a whole row dependent upon the contents of a single cell. You can't do that. It's simply not how Conditional Formatting works in Excel.
    If you're comparing the contents of each cell in a row/column to that of a single cell (via a formula), you can do it. I didn't highlight the cells, but rather set the text color to red or green based on the value of the cells in column A compared to C1. The same can obviously be done to highlight the cells.

    edit: n/m I finally see where ABF wanted to highlight several cells based on the contents of one cell in that range. Guess it doesn't matter anyway since he's done with whatever he was doing...lol
Sign In or Register to comment.