Conditional Formatting with rules

**howcroc** · 02-04-2011, 10:40 AM

Hello All,

I am working on a spread sheet were I require a cells date to turn Red if the date is within 5 days of today's date and also based on text within another cell, Is this possible?

I have attached an example.

Thanks.

**TechRetard** · 02-04-2011, 10:46 AM

i think this is what you want...put this in the conditional formatting for cell F3 and drag down

Please Login or Register  to view this content.

**brokenbiscuits** · 02-04-2011, 10:48 AM

I can't download your example for some reason, but do you need the cell to turn red if the date is >5 days ago AND or OR certain text is in another cell?

EDIT: Nevermind, I see it now, the above solution looks as if it'll work.

**MarvinP** · 02-04-2011, 10:50 AM

Hi howcroc,

Try this, see attached:

**howcroc** · 02-04-2011, 11:39 AM

Originally Posted by MarvinP

Hi howcroc,

Try this, see attached:

Hello, thanks all for all the help, I have opened the CondFormatAnd.xls, everything seems
to rely on what is in cell d3, am I using the right methods by using the format painter and dragging down?

How can I get Cell E10 to rely on D10?

Thanks,
Conrad.

**jwright650** · 02-04-2011, 11:51 AM

Hi Conrad,
Highlight Cell "E3"
Edit/Copy
Select the remaining cells in Column E to have the same formatting
Edit/Paste Special/tick Formats & Transpose/OK

**MarvinP** · 02-04-2011, 12:01 PM

Hi,

I used conditional formatting to do my example sheet. If you want to expand the range, I'd go into Conditional formatting and expand the range. To do this click on Conditional Formatting and then Manage Rules. If you don't see any rules click the dropdown to show on This Worksheet. Study this rule and change the Applies To range. If you need to use the rule in a different place, or other conditons on your sheet then see how this example works and apply it to your problem.
start here http://www.cpearson.com/excel/cformatting.htm