Hello
I have a range of data A2:D10. I have 2 rules. 1 Cell value between 1000 & 1999, format red fill, ^ 2 if Cell value greater than 2000 format yellow fill.
I then have a range of cell in F2:I10 that are signs of each of their corresponding cell in the 01st range, ie A2 has it's sign in F2 etc.
I want ot make these cell in F2:I10 have the same formatting rules of their cell correspondence in A2:D10.
Thanks
Why don't you use the same rules for highlighting the first range in the second range too?
Example in F2:I10 range..
=AND(A2>1000,A2<1999) for red fill
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
I mean something like this!
That's it. Thanks Fotis
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks