conditional formatting based on date in adjacent cell
I have a spreadsheet which needs a basic RAG format based on the cell adjacent.
For example column L contains the score, column M contains the empty box to be filled with colour based on the RAG status.
It should be formatted as follows:
Less than 18 = Green
18 = Amber
27 = Red
I'm not sure how to link it to the adjacent cell?
and thanks in advance for helping me out!
I have a set of 4 columns ( C to F) . I want the cell in C1 to be highlighted in a specific color (say red) if its value is LOWER THAN ALL the other values in D1 to F1). On the other hand, I want the cell in C1 to be highlighted another color (say green) if its value is HIGHER THAN ALL the other cell values in D1 to F1.
I've tried different methods but have been unable to accomplish this.
with applying conditional formatting in Excel 2003. I'm not sure how to apply conditional formatting.
I have three columns that contain dates and I need the cells to change colours based on whether there is a date in the corresponding cell of the next column and by how much time has lapsed since that date. I have attached a workbook with some examples of what I'm working on.
here. I'm trying to analyze a fairly large set of cross tab data using conditional formatting. Basically, I'd like to create a rule with two conditions:
1. The row contains a cell that's labeled "Index"
2. The value in the cell that is 2 to the right of the Index cell has a value of over 110.
Any ideas how I should go about executing this?
My last thread came back with no answers so I have made a few changes to my sheet hoping to make it possible.
How can I go about changing the colour of cell A1 when the date in B2 is more then 7 days old, then again to a new colour when it is 14days old. Im guessing it will be simply conditional formatting but cant quite get the formula right.
Or, if there is a way of doing this without using conditional formatting that would be better (because the date in B2 is only reading from another Tab, as conditional formatting wont read off another Tab, and I would rather not have to put in loads of new columns to read the date from other tabs on my front sheet.).
If you didn't see my first thread and think you can help then please see it <<HERE>>
Related Applications & Scripts
A very nice and easy way of giving your visitors a quick explanation of a button. It has an alpha animation (which you can also turn off). You can also apply html formatting like bold text.
Script allows developers to easily embed the functionality of calculating end time from a given start time and span into in 1/2 hour increments.
REQUIRES Cold Fusion 5.0 or MX to run- Uses "CreateTimeSpan" to translate both start time and time span into minutes. That way only a simple addition is required to determine end time.-"TimeFormat" is then used to return the start time and end time back to a HH:MM based time format.-Several of the "TimeFormat" formatting options are provided with this script.
This is a simple component that can be added to an application showing the current date (or a selected date).
It is easily skinnable using flex css styles.
This element enables you to pick dates with a simple slider bar. By dragging the bar over the time-line, the dates change instantly. Besides this, when the user decides to manually change the dates, the bar is automatically adjusted to the corresponding dates. As you are used to from us, the script is based on Prototype/Scriptaculous, but now combined with the DateJs library.