Previous Topic Next Topic

Formatting cell based on text in another sheet

Closed
RS - 13 Dec 2017 à 01:58
 Blocked Profile - 13 Dec 2017 à 16:35
Hello,

For e.g, I have "numeric" in cell B11 on sheet 1 with formula. However, I want the font color to change based on the text value in cell B2 on sheet 2 & sheet 3 and also on sheet 4 & 5; so if the text in cell B2 on sheet 2 & 3 is "Transferred to" I want the cell B11 on sheet 1 to change to GREEN; Similarly, if the text in B2 on sheet 4 & 5 is "Transferred from" I want the cell B11 on sheet 1 to change to BLUE

Is this possible?

thank you so much



1 response

Réponse 1 / 1
Blocked Profile
13 Dec 2017 à 16:35
OK so make a formula for cell B11. Take a look at this and see if it helps out:
https://ccm.net/forum/affich-910435-conditional-formating-formula-cell-text-change-color

Similar discussions

Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Conditional formatting based text in another cell
y88y -
y88y -

2 responses
Conditional Format Cells Based on Another Cell and Own Cell
Elaine -
x -

1 response
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses