Conditional formatting...if current cell contains x and another cell contains y

C

cainey1991

New Member
Joined
Feb 20, 2014
Messages
31
Hi all,

A question regarding conditional formatting.
Here is my current situation.

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Name[/TD]
[TD]DOB[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]John[/TD]
[TD]01/01/01[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Jack[/TD]
[TD]02/01/01[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]John[/TD]
[TD]01/01/01[/TD]
[/TR]
</tbody>[/TABLE]

I want it so that when there are 2 of the same names with the same DOB that all of those fields in A will be highlighted.

Any suggestions?
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
Sort by date Sort by votes
<html><head><title>Excel Jeanie HTML</title></head><body>
<!-- ######### Start Created Html Code To Copy ########## -->
Excel Workbook
ABCDEF
1NameDOBhelper
2John1/1/20011TRUE
3Jack2/1/20010
4John1/1/20011
5Luis3/4/20090
6John1/1/20011
Sheet1

?
?
<!-- ######### End Created Html Code To Copy ########## -->
</body></html>

 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Question Question
Conditional Formatting based on passed date
Replies
9
Views
428
SnKeaK
S
S
  • Solved
Conditional format dates in a range which are x days from today
Replies
3
Views
924
Sallyprit
S
B
  • Solved
OPTIMIZE my code
Replies
5
Views
294
BritsBlitz
B
S
  • Solved
Conditional Formatting - Highlight Cells to return Alphabetical only (amongst Alphanumerical entries)
Replies
7
Views
200
shauneyd
S
D
  • Solved
Using VBA to add a name to a cell
Replies
5
Views
181
deftincu
D

Forum statistics

Threads
1,223,164
Messages
6,170,444
Members
452,326
Latest member
johnshaji

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top