Conditional Formatting and Column Sorting

Afternoon everyone,

I am looking for some help with conditional formatting and Column Sorting, I am a very basic excel user so not even sure if the combination of rules I need is possible.

A google search on how to set conditional formatting didn't have the desired result after copying the code exactly just ended up in the whole column being highlighted.

Each row in my spreadsheet is data from a different report from the same system (not excel so entered manually) and each column is a different piece of info relating to that report. Here is what I need to do:

Column C needs to be sorted A-Z as it is a simple area identifying number, for example report in row 2 happened in area 2, report in row 3 happened in are 6 and so on...simples.

Row F needs to be sorted by date but I want Row C to be the dominant rule, so if I can put it in words that aren't gibberish, when both rules are run Column C will organise all reports by area from 1,2,3,4 etc and then in Row F reports will have a secondary sort in to date order but keeping them listed in report area from Column C. So all showing a 1 in C will be at the top and then sorted in date order, all showing in column C with a 2 will then follow and be sorted in date order.

Further to this I want the dates in Row F that are more than 20 days old from todays date to be highlight red.

Is this combination of rules possible? if so any pointers on how to set it up would be appreciated.

Hopefully that made sense as I don't know how to better explain it at half 5 on a Monday!

you should be able to manually sort
1st sort order is column C
then within that sort Column F (Add Level)

for conditional formatting

use

= F1 < = today() - 20

for 2007, 2010 or 2013 excel version
Conditional Formatting

Highlight applicable range >>

F:F


Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:


= F1 < = today() - 20


Format… [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK



OTHERWISE

Please upload a small clean sample of your data / workbook (not a picture) to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
We would like to see an example of your data and also a manual mock up of the expected results you want to achieve.

To attach a file to your post,
click "Go advanced" (next to quick post),
scroll down until you see "manage Attachments",
click that and select "Choose File" (top Left corner).
Find your file, click "Open" click "upload" click 'close windows" Top Right. click "Submit Reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.