Thanks in advance...
I am trying to keep track of sales by day for multiple stores. Columns are days (dates) and rows are multiple locations. Each day I log in the sales.
I would like the data that is entered to be GREEN if the amount I enter is greater than the previous days sales and RED if less (ie if D6>C6, then green, if D6<C6, then Red). This way I can easily see the trend, instead of mentally figuring out if its higher or lower.
Any ideas??
You will need two separate rules. You will highlight all your sales data except the first day, and your formulas will refer to the upper-left cell of your sales data. Suppose you have one row of headings and one column of headings and the second day of your data starts in C2. You will use a custom formula:
=C2>B2
and use color green
second rule:
=C2<B2
and use color red
For a more specific solution tell us where your data is. For help putting in your file, attach your file. Under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
Jeff, thanks for the quick reply.
Let me try to attach a sample sheet. What I want to see is either a red or green number (except for the first column of data). Green if it exceeds the previous days revenue and red if it is less. Does that make sense?
could you plz help me too ...
Cell A1 is equal to a cell which is in another workbook
i wanted to check if the value of cell A1 > 3000 (Cell A1 has 250) however it is returning True
Note : Cell A1 = A1 from a different worksheet which i dont have any control off and is live and the value keeps changing
I tried formating my workesheet A1 cell to number ...no go ....
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.Originally Posted by james12.jo
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Here is my description implemented in your file. I went out to column Z. If you need more rows or columns, just adjust the range applied in the CF rules (no need to change the formula).
Boy, that is great. Thank you much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks