Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

Excel Formula Help


(!)

bailey37130's Avatar
bailey37130 bailey37130 is offline
Member with 4 posts.
THREAD STARTER
 
Join Date: Jun 2012
08-Jun-2012, 05:01 PM #1
Excel Formula Help
I'm making an excel sheet and I'm having trouble figuring out the formula to automatically highlight the cell intersection point of a date in a row that equals the same date in a column.
etaf's Avatar
etaf   (Wayne) etaf is offline
Computer Specs
Moderator with 52,048 posts.
 
Join Date: Oct 2003
Location: Surrey, UK
09-Jun-2012, 06:49 AM #2
can you explain further - or post some dummy data
Garf13LD's Avatar
Garf13LD Garf13LD is offline
Member with 455 posts.
 
Join Date: Apr 2012
Experience: Intermediate
10-Jun-2012, 10:10 PM #3
Try index/match combo
bailey37130's Avatar
bailey37130 bailey37130 is offline
Member with 4 posts.
THREAD STARTER
 
Join Date: Jun 2012
11-Jun-2012, 03:31 PM #4
Date 5/13 5/14 5/15
5/13
5/14
5/15

I want to highlight the space the dates intersect
etaf's Avatar
etaf   (Wayne) etaf is offline
Computer Specs
Moderator with 52,048 posts.
 
Join Date: Oct 2003
Location: Surrey, UK
11-Jun-2012, 03:49 PM #5
I assume the dates are in
column B1,C1,D1
Row A2,A3,A4

ok so conditional format should woork

=IF(A2=B1,true,false)
trying to work out how to copy that copy>paste special format
and not getting it

I guess in B2
=IF($A2=B1,true,false)
and copy horizontal
then in B3
if(A3=B$1,true , false)
and copy vertically
bit i think you will need to do that for each cell and copy down
__________________
Wayne
Please let us know what the final solution was to any problem posted
bailey37130's Avatar
bailey37130 bailey37130 is offline
Member with 4 posts.
THREAD STARTER
 
Join Date: Jun 2012
11-Jun-2012, 04:56 PM #6
When I entered that in I could get the entire row to highlight, except the one cell that should. Let me add a little more and see if this makes a difference

Date 5/13 5/14 5/15
5/13 5/14
5/14 5/14
5/15 5/15

Some dates go multiple dates so I would need both those dates represented in the highlight
etaf's Avatar
etaf   (Wayne) etaf is offline
Computer Specs
Moderator with 52,048 posts.
 
Join Date: Oct 2003
Location: Surrey, UK
11-Jun-2012, 05:11 PM #7
Quote:
Some dates go multiple dates so I would need both those dates represented in the highlight
don't understand
Quote:
I assume the dates are in
column B1,C1,D1
Row A2,A3,A4
can you post some dummy data so we can see the format
bailey37130's Avatar
bailey37130 bailey37130 is offline
Member with 4 posts.
THREAD STARTER
 
Join Date: Jun 2012
11-Jun-2012, 05:20 PM #8
Dates 5/13 5/14 5/15 5/16
5/13 5/14 x x
5/14 5/14 x
5/15 5/16 x x

The x's would be the cells I would need to automatically highlight
etaf's Avatar
etaf   (Wayne) etaf is offline
Computer Specs
Moderator with 52,048 posts.
 
Join Date: Oct 2003
Location: Surrey, UK
11-Jun-2012, 05:50 PM #9
what cells are the dates in coloured red
Quote:
Dates 5/13 5/14 5/15 5/16
5/13 5/14 x x
5/14 5/14 x
5/15 5/16 x x
Keebellah's Avatar
Keebellah   (Hans) Keebellah is offline Keebellah is a Trusted Advisor with special permissions. Keebellah has a Profile Picture
Computer Specs
Trusted Advisor with 5,271 posts.
 
Join Date: Mar 2008
Location: Oegstgeest, The Netherlands
Experience: Advanced
12-Jun-2012, 01:48 AM #10
Dummy data is an Excel file with data!
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
WELCOME TO TECH SUPPORT GUY!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.


Tags
excel, excel 07, formulas

(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑