Conditional formatting

I am looking for some help in applying a conditional format to a number of cells in a number of different rows.
The criteria is as follows;
If the current cell value is greater than 0,
the value of the cell in the same row, but column C is greater than $A$1

I have tried a number of things but it keeps reverting either to a text line in the condition, or giving an error.

I am at home at the moment, and do not have Excel on this laptop.
I will check in again from work tomorrow.

Thanks in advance.
Stephen ByromWarehouse/ShippingAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

NorieAnalyst Assistant Commented:
Which rows/cells do you want to apply the formatting to?
Give this a try:

Conditional Formatting > New Rule . Use a formula to determine which cells to format:
Then use the format painter to copy the conditional formatting.

Good luck!
Assuming the cell in question is in column B this works perfectly using a single formula:
OWASP: Avoiding Hacker Tricks

Learn to build secure applications from the mindset of the hacker and avoid being exploited.

I messed up a little on mine. OCDan had a better approach, but to be able to apply the formatting to different columns, you'd want to take off the first $:
Nice amendment Apothis, makes it a lot easier to use on a number of columns.
Thanks, the AND function was far better than applying 2 rule in my approach, then I forgot to add to stop if true, and I had my > should have been <=. So what I was trying to accomplish:

=D2<=0          (apply no formatting changes) (stop if true)
=$C2>$A$1   (your desired formatting)
NorieAnalyst Assistant Commented:
Did I miss something?

Where did column D come into this?
D, or B, or E was the 'current cell', as we weren't sure where you wanted to apply the formatting.
Stephen ByromWarehouse/ShippingAuthor Commented:
Thanks to both for the advice.
I have tried a couple of ways to get it to work, to no avail.
I have attached a copy of the sheet in question so that you can see what I am after.
The numbers in columns G, J, M.....etc. etc. need to change to something noticeable (maybe yellow fill red font) if, (the number is >0 AND the date in column C of the same row is greater than the value of A1.)  We need to be able to notice quickly if we have more than 10 day's stock of any product item, which is why the formula in A1 is "Today()+10"

I update this sheet on a weekly basis and copy/insert copied rows every two weeks, so I would like the conditional formatting to copy down.

I managed to get a simple condition to work with less than 0, but the compound condition and relative to column C of the same row, has me baffled.
Thanks for your time.
NorieAnalyst Assistant Commented:
Which cells do you actually want to format?

In the attachment you seem to be formatting columns B:AQ, not just columns G, J and M.
Stephen ByromWarehouse/ShippingAuthor Commented:
I have a number of formats going on. But what I need is the numbers in columns G, J, M.....etc. (stock on hand) to change format when the stock on hand is greater than zero AND the date in column C of the same row is greater than the value of A1
NorieAnalyst Assistant Commented:
Select E4:AQ84, goto conditional formatting, enter this formula and format as required.


This checks the value in the cell, checks the date in column C of the row against A1 and checks if the cell is in columns E-AQ and if the column is the 3rd.

If all are checks are true it returns TRUE.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Stephen ByromWarehouse/ShippingAuthor Commented:
Thanks so much for your time!
Looking at the complexity of the formula, I know I would have never worked that out.
Thanks again.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.