Conditional formatting

[asyamonique]

Good Day,
I'm trying to format the column C:E row texts base on the formatted(by conditional formating!) column P values.
Column P formatted wih red&yellow;
The cells fills red if the values less than -4000 which linked to U1(-4000)
The cells fills yellow if the values greather than 5000 which linked to V1(5000)

My question is how can ı format those row texts with same color as well(column C:E)?
Many thanks

 

[Marcelo Branco]

Not sure what you want.

Maybe this...
Assuming data in row 2 (C2:E2)
Select C2:E2

Rule 1
Use a formula to determine...
=$P2 < $U$1
Fill ---> Red

Rule 2
Use a formula to determine...
=$P2 >$V$1
Fill ---> Yellow

M.

 

[asyamonique]

Thanks a lot