Distributor Monthly Summary Josh test.xlsx
Hey Guys,
In B17 is the predicated figure for the end of month, in C17 - H17 is the actual figure so far.
Would it be possible to have cell's C17-H17 show green if the actual figure is tracking ahead or in line with where it should be for the current time of the month and red if not?
If so how would I go about that?
Many Thanks
Not sure that i got your goal..Something like this?
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
I'm sorry I should have specified the sheet!
The calculation needs to happen in the Distributor Summary Sheet it probably makes more sense now!
Ahaa..
Try this in Conditional formatting rules
=TEXT(TODAY(),"mmm")=$C2
How do I go about doing that?
Hit F1 - Enter "conditional formatting" It's all there
I'm on a Mac, if I got into conditional formatting and add new rule all I get is drop downs nowhere to enter a formula?
I really appreciate all your help but it isn't seeming to be having the desired effect, Im sure its I'm doing
And I appreciate very much your kindness that's why i do my best trying to help you.
When we use use the text function with dates i try to don't post a sample worksheet because in Greece we have different local settings for months-dates that in fact are text. So in Conditional Formmating rules you will see this formula.
=TEXT(TODAY();"μμμ")=C$2
μμμ in Greek=mmm in English.
so do it like this.=TEXT(TODAY(),"mmm")=C$2
Also in row 2 i used the Greek name of the months. Replace these with English ones...
Hope that helps..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks