Forum Discussion
Conditional formatting to include text from cell reference
I am using a Gantt calendar in which the daily cells are formatted to prefill a color provided it falls within a date range, example: =AND(task_end>=K$4,task_start<L$4). How can I add a COUNTIF formula to point to a specific cell and reference text (while keeping this original formula/condition)? Thanks in advance for your assistance.
Here a file with the example and also a file with various examples for the conditional formatting.
Formula =AND($A2="Test",$B2="haus")
If you have a future question, please read the information in this link (at the end) and include this information in your request. In this way you could get a solution proposal much faster and more precisely and it saves the helpers time, with which they can answer more questions. Win-win for everyone.I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
2 Replies
Here a file with the example and also a file with various examples for the conditional formatting.
Formula =AND($A2="Test",$B2="haus")
If you have a future question, please read the information in this link (at the end) and include this information in your request. In this way you could get a solution proposal much faster and more precisely and it saves the helpers time, with which they can answer more questions. Win-win for everyone.I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
