mikes6058
asked on
conditionally format range based on cell value
I need to conditionally format the range I4:I40 so that;
If any cell within this range is equal to any of the values in the yellow cells in column H then they will be shaded red. If they are not equal they will be shaded green.
note; the cells highlighted yellow in column H have only been highlighted to demonstrate the cells to look against. They will always be in the same locations but will not necessarily be highlighted yellow. the values of these cells will change.
fantasy-football---predicter.xlsx
If any cell within this range is equal to any of the values in the yellow cells in column H then they will be shaded red. If they are not equal they will be shaded green.
note; the cells highlighted yellow in column H have only been highlighted to demonstrate the cells to look against. They will always be in the same locations but will not necessarily be highlighted yellow. the values of these cells will change.
fantasy-football---predicter.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
That's strange. Drop down list in col. H is working perfectly in the workbook I attached with my reply.
I cross checked by downloading my file and its working without an issue.
You may change the drop down value in col. H.
I cross checked by downloading my file and its working without an issue.
You may change the drop down value in col. H.
![Avatar of [ fanpages ]](https://filedb.experts-exchange.com/files/public/2020/2/28/4acbe344-900b-4e79-96ce-65fe58a6f004.png){kind=small}
Hi Mike,
Did you add the drop-down lists between listing your question initially, then deleting it, & re-posting?
I was already working on a solution when you deleted the first question.
Sorry, I had not noticed a change in the two workbooks you posted.
I have now applied the Conditional Formatting to the workbook at the top of this question thread.
A new attachment is below for your further review.
Q-28708153b.xlsx
Did you add the drop-down lists between listing your question initially, then deleting it, & re-posting?
I was already working on a solution when you deleted the first question.
Sorry, I had not noticed a change in the two workbooks you posted.
I have now applied the Conditional Formatting to the workbook at the top of this question thread.
A new attachment is below for your further review.
Q-28708153b.xlsx
ASKER
I got to the botton of the dropdown problem. I created and uploaded the file from 2010 I then downloaded your files from a different machine using 2007.
All sorted now.
Great work guys
Mike
All sorted now.
Great work guys
Mike
Thanks Mike :)
You're welcome Mike!
ASKER
It appears as if both of you have removed the drop down lists in the yellow cells in column H. These need to remain so that the values in these can be changed by the end user.
for some reason its not allowing me to add the drop down lists back in???
Mike