if cell = text between date range mark cell red - conditional formatting?

**distro** · 06-02-2013, 10:50 AM

Hi!

I have a table with the following set up:

Column A = dates
Column E, F, G, H = Drop box with text
Cell B2 = Output from formula

What I wish to do is: If a date between de 01 and 31 january in Column A is present search for text in Columns E, F, G, H and mark Cell B2 or with text or fill.

The formula I'm using to sum numbers in date range is: =SUMIF(column A,">="&DATE(2013,1,1),column B)-SUMIF(Column A,">"&DATE(2013,1,31),Column B)
And a formula that filters keywords: =IF(B2="Dianteiro direito","POSITIVE", "")

Is there a way to combine this 2 formulas? having the last formula to search Columns E, F, G and H for text that matches the criteria?

Thank you for any replies

**protonLeah** · 06-02-2013, 04:00 PM

To Attach a Workbook:
1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit

if cell = text between date range mark cell red - conditional formatting?

LinkBack

Thread Tools

Rate This Thread

Display

if cell = text between date range mark cell red - conditional formatting?

Re: if cell = text between date range mark cell red - conditional formatting?

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions