Formatting cell based on text in another sheet
Closed
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
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
Related:
- Formatting cell based on text in another sheet
- Sheet right to left in google sheet - Guide
- Windows network commands cheat sheet - Guide
- Mark sheet in excel - Guide
- Instagram account based in wrong country - Instagram Forum
- Excel macro to create new sheet based on value in cells - Guide
1 response
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
https://ccm.net/forum/affich-910435-conditional-formating-formula-cell-text-change-color
