Conditional Formatting
Hi All
This is my first post here.
I use excel at work all the time, but I am having a bit of trouble coming up with a formula for this situation.
Let's say D60, D10, A7, D8 are the cells with the required data, with D60 being the cell to be conditionally formatted.
I want this cell to be conditionally formated based upon:
D60+D10 > A7 only when (D8<A7)
How would I write this in a transposable formula to be dragged across horizontally.
Thanks,
Conditional formats respond to formulas that provide a true or false result. Try using:
For the "transposable" portion of your question, it depends on what you want to be fixed. If you have a constant in A7 for example, then maybe try:
=AND((D60+D10)>A7,D8<A7)
Cheers,=AND((D60+D10)>$A$7,D8<$A$7)
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
Did this solution work for you?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks