Color cells in certain criteria

[rathf1]

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.

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

 

[Mel Smith]

Have you looked at conditional formatting?

Mel

 

[rathf1]

I have but I can't get it to do it based on two diferent criterias..

 

[Andrew Poulsom]

Via PM:

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]

Thanks! Mr. Poulsom,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
It works great thank you!<o></o>
<o></o>
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></o>
<o></o>
Thank you for your time and help.<o></o>
<o></o>
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" oreferrelative="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><vath o:connecttype="rect" gradientshapeok="t" o:extrusionok="f"></vath><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></o>
<o></o>
V/R<o></o>
Daniel Perez<o></o>

 

[Andrew Poulsom]

Try:

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

 

[rathf1]

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

Thank You Again for all your help

V/R
Daniel Perez