Color cells in certain criteria

rathf1

New Member
Joined
Nov 11, 2010
Messages
8
Hello everyone,

I have a delema with excel I need a formula or a macros that will alow me to pick a color for ex. Colum B1-100, if name matches in Colum D1-100, but I only want it to highlight lets say green when the date is todays date. :confused:

can anyone please help me out I reviewed the posts for days and cant seem to find anything. I am no good at macros so....:) thank you

V/R
Daniel Perez
Perezunlimited.com
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Mel Smith

Well-known Member
Joined
Dec 13, 2005
Messages
855
Office Version
  1. 365
Platform
  1. Windows
Have you looked at conditional formatting?

Mel
 

rathf1

New Member
Joined
Nov 11, 2010
Messages
8
I have but I can't get it to do it based on two diferent criterias..
 

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Via PM:

rathf1 said:
Hello Sir,

Sorry to write you directly but it seems that you can help me with this problume i have.

I am trying to highlight cell B3, if cells G:G have the same name as B3.... but I only want it to highlight that cell if J:J has todays date.

so cell B3 displays sousa... and cell G21 displays sousa and cell J21 is todays date so cell B3 should highlight green lets say. can you please help me out.. Thank you for your time. :)

V/R
Daniel Perez

Try the conditional formatting formula:

=AND(B3=G3,J3= TODAY())
 

rathf1

New Member
Joined
Nov 11, 2010
Messages
8

ADVERTISEMENT

Thanks! Mr. Poulsom,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:eek:ffice:eek:ffice" /><o:p></o:p>
<o:p></o:p>
It works great thank you!<o:p></o:p>
<o:p></o:p>
The only issue I have is that "J3" is "=TEXT(Sheet3!E3,"dd-mmm-yy")" I have inserts a formula to copy sheet 3 where all the appointment information is located but the formula you gave me will not recognize the formula as = today(), probably because it is a formula and not a date.<o:p></o:p>
<o:p></o:p>
Thank you for your time and help.<o:p></o:p>
<o:p></o:p>
So close yet so far away <?xml:namespace prefix = v ns = "urn:schemas-microsoft-com:vml" /><v:shapetype id=_x0000_t75 stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" o:preferrelative="t" o:spt="75" coordsize="21600,21600"><v:stroke joinstyle="miter"></v:stroke><v:formulas><v:f eqn="if lineDrawn pixelLineWidth 0"></v:f><v:f eqn="sum @0 1 0"></v:f><v:f eqn="sum 0 0 @1"></v:f><v:f eqn="prod @2 1 2"></v:f><v:f eqn="prod @3 21600 pixelWidth"></v:f><v:f eqn="prod @3 21600 pixelHeight"></v:f><v:f eqn="sum @0 0 1"></v:f><v:f eqn="prod @6 1 2"></v:f><v:f eqn="prod @7 21600 pixelWidth"></v:f><v:f eqn="sum @8 21600 0"></v:f><v:f eqn="prod @7 21600 pixelHeight"></v:f><v:f eqn="sum @10 21600 0"></v:f></v:formulas><v:path o:connecttype="rect" gradientshapeok="t" o:extrusionok="f"></v:path><o:lock aspectratio="t" v:ext="edit"></o:lock></v:shapetype><v:shape style="WIDTH: 12pt; HEIGHT: 15.75pt; VISIBILITY: visible; mso-wrap-style: square" id=Picture_x0020_1 alt="0" type="#_x0000_t75" o:spid="_x0000_i1025"><v:imagedata o:title="0" src="file:///C:\Users\DANIEL~1.PER\AppData\Local\Temp\msohtmlclip1\01\clip_image001.gif"></v:imagedata></v:shape><o:p></o:p>
<o:p></o:p>
V/R<o:p></o:p>
Daniel Perez<o:p></o:p>
 

rathf1

New Member
Joined
Nov 11, 2010
Messages
8
Mr. Poulsom,

It took me a minute but I got it to work thank you. In order for it to work i changed the formula and added today() in cell A1 thus the formula now reads.... {=AND(B3=G3,J3+0=A1)} were A1 is the formula =Today() then it worked perfectly :biggrin:

Thank You Again for all your help :cool:

V/R
Daniel Perez
 

Forum statistics

Threads
1,141,018
Messages
5,703,756
Members
421,313
Latest member
Mooncake1

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
Top