HuskyJones
New Member
- Joined
- Sep 30, 2015
- Messages
- 45
- Office Version
- 365
- Platform
- Windows
Hi Hive!
Below is a pic of what i've tried that hasn't worked.
I want cell P6 (red circle) to match the colour of whatever N6 does. So if I put a 2 in N6 I want P6 to go orange no matter what text is in there, If I put a 4 in N6 I want P6 to go red no matter the text in there.
(I'll then copy to the other cells that i want this in)
I've reached my brain capacity to sort this.
(i'm on 365)
Thanks folks
Below is a pic of what i've tried that hasn't worked.
I want cell P6 (red circle) to match the colour of whatever N6 does. So if I put a 2 in N6 I want P6 to go orange no matter what text is in there, If I put a 4 in N6 I want P6 to go red no matter the text in there.
(I'll then copy to the other cells that i want this in)
I've reached my brain capacity to sort this.
(i'm on 365)
Thanks folks