Forum Discussion

IJSKO's avatar
IJSKO
Copper Contributor
Sep 03, 2019

custom layout worksheet

I'm looking for a way to get something done   Say I have a cell in sheet1 and i'm giving it the value of a cell in sheet2 by putting a referral to it on sheet1. Originally the fontcolor in sheet2 ...
excel
Formulas and Functions
nabilmourad's avatar
nabilmourad
MVP
Sep 03, 2019

IJSKO 

Hi

our Team mate tauqeeracma  has guided you correctly to conditional formatting rule.

I would suggest tauqeeracma  to add a second rule to achieve the desired outcome (same exact concept but, when condition when is not met, condition 2 will take over

Good Luck

Nabil Mourad

  • tauqeeracma's avatar
    tauqeeracma
    Iron Contributor
    Sep 03, 2019

    Thanks nabilmourad .

     

    I think the second rule will also not help because as per my understanding the requirement is to colour the cell if it is being called in another sheet. Whereas I put a conditional formatting rule in the cell that receives value from other sheet. 

     

    Sample data file will surely help to suggest more specific solution.

    Tauqeer

Resources