Conditional fomatting to highlight cells based on cell address in another column?

  • Hi!


    I have an excel sheet where certain cells in Col. A, B, C need to be highlighted with conditional formatting using colour fill in cells.


    However, the cells in which conditional formatting is to be applied, is to be determined by cell addresses given in Col. E.
    Is it possible to determine the cells to be conditionally formatted, using addresses given in cells in Col. E with Indirect function in Conditional Formatting OR any other method to arrive at the result?


    Sample file attached.


    Regards,
    Naira

  • Re: Conditional fomatting to highlight cells based on cell address in another column?


    You could use this formula, but it will only colour them the same


    =COUNTIF($E$2:$E$4,ADDRESS(ROW(),COLUMN(),4))>0


    You could faff around with CF, or use VBA for individual colours.

  • Re: Conditional fomatting to highlight cells based on cell address in another column?


    Hi Stephen,
    Your solution is PERFECT and EXACTLY as desired.
    I gave multiple colours so that the people helping out can make out cell being referenced and its address.
    Also. it is possible to get multiple colours by having your solution in each individual column.
    Thanks a lot anyways.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!