Conditional formatting - Transfer (original) code to another tab sheet

Hello,

Nice to meet you all. I'm new to the forum and I have a question about conditional formatting and I was wondering if you could help me with this..

I have two tab sheets. I have in the first tab sheet a cell (B21) with a the following conditional formatting code: =ISNUMBER(B21)..then the cell will turn green if a number is filled in.
What I want is that cell A1 in the second tab sheet will also turn green if a number is added in cell B21 from tab sheet 1

I can copy the cell and then paste it in the second tab sheet but then the conditional code in the A1 cell is =ISNUMBER(A1) but I want it to refer to tabsheet 1, which is =ISNUMBER(B21)
Anyone know how to do this?

Thanks, Vincent

Yes thanks. Now i have created a new sheet with one more problem. Do you happen to know how to solve?

I have attached the form. Problem is that Cell C2 "overview" is turning green when it should not because the date in not filled in.

Yes, I know. But when I remove B17 from tabsheet "input form" the code in cell B2 stays the same ='Input form'!D3 but then the green color is gone (in B2)

And when you for instance fill in 20 aug 2018 in B11 tabsheet "input form", cell B2 in the first tabsheet will color red..

Thanks for your reply! I don't understand it yet..
What do I have to change to make it work?


1 When "Teleconferene" is filled in = always green

2 When "sub form received" is filled in with a date, the
other ones should also turn green when a date is filled in.
When e.g. "information pack" is not filled in with a date it should stay blank
(when "Sub form received" is filled in with a date)

3 For "information pack" and "invitation pack":
When sent (from date today)
15 days after today = Blue
30 days after today = Yellow
150 days after today = Purple