Conditional fromatting formula
My current formula: =IF(AND($H4<>"",$I4<>""),J
you cannot use J4 in this formula J4=MEDIAN(J4,$H4,$I4)
could you post a sample workbook as your initial formatting is not clear
gowflow
gowflow
ASKER
Uploading now...
Also your not telling us your conditional formatting apply to what range and cells.
gowflow
gowflow
I Updated the attachment, please try it again.
ASKER
Sorry for the delayed response. What I'm trying to is have the dates created a Gantt chart but I want it to based upon date range and category. So each category will be a different color.
125-Maint-Analysis_Events_database-v.xls
125-Maint-Analysis_Events_database-v.xls
sorry the file you posted is
125-Maint-Analysis_Events
However when we open it is a Word document !!! ending with .doc
check what you posted as this is an Excel thread and repost the correct file.
gowflow
125-Maint-Analysis_Events
However when we open it is a Word document !!! ending with .doc
check what you posted as this is an Excel thread and repost the correct file.
gowflow
Create your chart then use Conditional Formating and Manage Rules for those cells.
How to manage Rules:
Select the cell(s) you want to apply the rules.
Select Home tab from above excel.
Click on Conditional Formating and select Manage Rules.
Select New for creating new roules to edit to edit rules.
How to manage Rules:
Select the cell(s) you want to apply the rules.
Select Home tab from above excel.
Click on Conditional Formating and select Manage Rules.
Select New for creating new roules to edit to edit rules.
@Gowflow - if you change the file type to XLS it's OK.
ASKER
Sorry. I'm working in excel. So, maybe inadvertently uploaded wrong file. Here you go...
125-Maint-Analysis_Events_database-.xlsx
125-Maint-Analysis_Events_database-.xlsx
ok now we are talking. The file is fine and nice by the way !!!
Lets go back to what you want.
When you have training or Inspection in G4 what you want to color ??? you want to add the existing formula ? or simply color the word training and inspection ?
gowlfow
Lets go back to what you want.
When you have training or Inspection in G4 what you want to color ??? you want to add the existing formula ? or simply color the word training and inspection ?
gowlfow
Is this what your looking for ? See the attached file.
gowflow
125-Maint-Analysis_Events_database-.xlsx
gowflow
125-Maint-Analysis_Events_database-.xlsx
ASKER
I want to modify or change the existing conditional formatting formula to highlight the corresponding date range with the category. If you unhide the rows up top you will see the categories or loo at the drop-down tab. I have seven (7) categories.
I see
Just 1 comment:
January is fine but February till December does not have does not have
Details Venue Command Location Category Start Date End Date
Shouldn't you first add them so we fix the whole Workbook in 1 go ?
gowflow
Just 1 comment:
January is fine but February till December does not have does not have
Details Venue Command Location Category Start Date End Date
Shouldn't you first add them so we fix the whole Workbook in 1 go ?
gowflow
ASKER
If you think that's best. I was planning on applying the solution to remain spreadsheet. But ok.
don't worry just be patient I am doing all this for you. Will get back as hv to step out for few hours.
gowflow
gowflow
Is this what your looking for ?
I don't understand why but in every row where you have dates the 2 and 3 are colored is this fine ??
I modified the wb to accommodate the formula to include the whole workbook also adjusted the headings for all months and incorporated training and inspection.
Not too sure about what it should color though !! if you can advise then maybe will fix the formula to color the correct range. My feeling is that you want to color the date range is that correct ??
Let me know your comments.
gowflow
125-Maint-Analysis_Events_database-.xlsx
I don't understand why but in every row where you have dates the 2 and 3 are colored is this fine ??
I modified the wb to accommodate the formula to include the whole workbook also adjusted the headings for all months and incorporated training and inspection.
Not too sure about what it should color though !! if you can advise then maybe will fix the formula to color the correct range. My feeling is that you want to color the date range is that correct ??
Let me know your comments.
gowflow
125-Maint-Analysis_Events_database-.xlsx
ASKER
The is exactly what I was looking for. I have attached a spreedsheet with a legend at the top. The colors key can be anything, but I would like FHP - Red, UTA- Blue, etc.,
125-Maint-Analysis_Events_database-.xlsx
125-Maint-Analysis_Events_database-.xlsx
yes but first is the formula ok ? about the 2 and 3 that are being colored is it fine ?
gowflow
gowflow
ASKER
Yes, exactly what I needed.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
yes, but the colors can be whatever...
ASKER
Are the cells highlighting properly.
What do you mean by:
colors can be whatever...
and
Are the cells highlighting properly.
Sorry I don't understand what you want and what you are commenting. Please be more explicit.
gowflow
colors can be whatever...
and
Are the cells highlighting properly.
Sorry I don't understand what you want and what you are commenting. Please be more explicit.
gowflow
ASKER
Meaning whatever coloring you setup is good with me. When you enter the dates are highlight cells correctly
ok you need now all the items listed in legend to be included in the color formatting ? if yes then I suggest you close this question as it has answered your initial request and post a new question. If you would like my help then please put a link here of the new question and I will be glad to help.
gowflow
gowflow
ASKER
Thank you. New question posted.