Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting help
Hello,
I posted a question last night but see that I have one piece to finish my spreadsheet. Here it is... I have a Gantt Chart that I am developing in excel. Basically I have conditional formatting that compares the date range of a particular task to the actual date and thus fills in small excel squares showing visually how things are progressing in the timeline. It shows in little green squares When the task starts and when it is supposed to end. Here is a screenshot of what it looks like. http://download.shireinteractive.com/images So basically as you can see on row 31 I have the text grayed out because 'X" is in the field B31. I would like to apply that same grayed out effect to the green date range on the right in row31. Currently that date range code looks like this. =IF(AND(V$3=$E13,V$3<=$F13),1,"") There is then a conditional formatting applied to that cell telling it that if it equals "1" to make that cell green. Right now anything that is not in the date range is white, Anything that is in the date range is green. I want to add one more component, anything that is in the date range and has an "x" in the B column in that row, I want it to turn that green date range to Gray. Is this possible? If this doesn't make sense please let me know and I will try to explain in a different manner. I have also posted the excel spreadsheet in that link above for your convenience. As always thanks for your time. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting a range with conditional formatting | Excel Worksheet Functions | |||
conditional formatting glitches | Excel Discussion (Misc queries) | |||
Keeping conditional formatting when sorting | Excel Discussion (Misc queries) | |||
conditional formatting | Excel Discussion (Misc queries) | |||
cannot use ISEVEN or ISODD functions in Conditional Formatting | Excel Worksheet Functions |