Formatting cell based on text in another sheet [Closed]

Question

Formatting cell based on text in another sheet [Closed]

Report

RS - Dec 13, 2017 at 01:58 AM
Blocked Profile - Dec 13, 2017 at 04:35 PM

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

Formatting cell based on text in another sheet
Formatting cells based on certain criteria ✓ - Forum - Excel
How to format cells based on the text in another cell ✓ - Forum - Excel
Conditional format to highlight cell based on date ✓ - Forum - Excel
Conditional Formatting range of date cells based on another cell ✓ - Forum - Excel
Format cell color based on date range ✓ - Forum - Excel

1 reply

Ask a question

Blocked Profile · Answer 1 · 2017-12-13T16:35:06-0500

Answer 1 / 1

Blocked Profile
Dec 13, 2017 at 04:35 PM

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

Formatting cell based on text in another sheet [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!