Good Day all
I have been experiencing an issues with a very small spreadsheet, causing me a major headache. I have a set of key dates across columns M, N, O on row 4.
M4= First Draft
O4= Mobilization/ Start Date
First draft needs to be received 8 weeks prior to mobilization and final...
I have a 'Planned Date' column (V) and I need to apply the following conditional formatting RAG status:
Four weeks prior to date in column 'V' the date needs to be highlighted Green
Between 3 and 2 weeks prior to date in column 'V' the date needs to be highlighted Amber
1 week or less...
I've had a quick search and I have not returned any results for this.
My issue is a simple one, but I cannot find a way to do it with conditional formatting in excel 2010. (not that I'm an expert!) I have a number of cells which I have conditionally formatted to be green, amber or red...
I have a problem where I am trying to get the RAG status for some values, built into a macro that will perform conditional formatting based on >= values or <= value. the Conditions for both will be different.
So I need the currentl value to be analysed in terms of two scenarios...
I have the requirement of comparing 2 columns and highlighting 3rd column with the appropriate colour. I am using MS Excel 2003 version
A1 - '01-Nov-2009'
B1 - '10-Nov-2009'
Compare A1 & B1. If A1 is less than B1, set "Green colour" background in C1 column...