Forum Discussion
Solved
Cells font color based on input formula in Excel
Hi! I would like to change the font color of the cells of row "K" based on the input formula. For example if the formula is=$C$2*J9 then the font color of cell "K9" should be blue, if the formula is...
Hi ballatoma
Provided you run Excel >/= 2016. Cond. Format rule with formula, for Blue font:
=ISNUMBER( SEARCH( "$C$2", FORMULATEXT( K9 ) ) )NB: not clear what your 1st row of data is, so adjust K9 if necessary
Then setup a 2nd rule for Red font similarly changing $C$2 with $E$2
AND as "Its a big table" don't forget to check the box Stop if true next to the 1st rule
Hi ballatoma
Provided you run Excel >/= 2016. Cond. Format rule with formula, for Blue font:
=ISNUMBER( SEARCH( "$C$2", FORMULATEXT( K9 ) ) )NB: not clear what your 1st row of data is, so adjust K9 if necessary
Then setup a 2nd rule for Red font similarly changing $C$2 with $E$2
AND as "Its a big table" don't forget to check the box Stop if true next to the 1st rule
