Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Nov 2006
    Posts
    48
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Combining formula and conditional formatting (Excel 2003)

    Is it possible to set conditional formatting for a particular cell based not on the value of that cell but on the value of another cell? For example, could conditional formatting for column K be based upon the values of cells in column J meeting certain criteria? So the formatting for cell K73 might depend upon the value of J73?

    And going one step further, can the formatting of one cell be determined by the formatting of another cell? Can the formatting of column K be set ton reflect that of column J, for example, cell by cell?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Combining formula and conditional formatting (Excel 2003)

    You can use formulas in conditional formatting. Example:
    - Select column K. Note which cell is the active cell within the selection (probably K1).
    - Select Format | Conditional Formatting...
    - Select Formula Is from the dropdown list.
    - Enter (for example) <code>=J1>50</code> in the box next to it.
    - In the formula, J1 corresponds to the active cell K1. If the active cell had been K3, you'd have used J3 in the formula.
    - Click Format... and specify the formatting you want, then click OK.
    - Add more conditions if necessary.
    - Finally click OK.

    Second question: no, not really. Conditional formatting only applies to the font, background color and cell borders, but not (for example) the number format or alignment.

  3. #3
    Lounger
    Join Date
    Nov 2006
    Posts
    48
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combining formula and conditional formatting (Excel 2003)

    Thanks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •