Conditional Formatting across worksheets

danskii1

New Member
Joined
Mar 1, 2019
Messages
1
Hi,

I will try and make this all make sense....

I have a spreadsheet with 3 work sheets, A,B,C for ease

sheet A is master, in which I have columns A - K, Column B has a ref number, this ref number is also in Sheet C

on sheet A in column I, I have a drop down list of Y, N, U which I have set in conditional formatting to go green,red and orange respectively

what I want to also happen is the ref number in sheet C (same as ref number in sheet a) to also turn green, red or orange at the same time.

I hope this makes sense, and i hope this is possible.

Thanks
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Watch MrExcel Video

Forum statistics

Threads
1,108,993
Messages
5,526,114
Members
409,685
Latest member
Bellybb

This Week's Hot Topics

Top