Conditional formatting: change color for a range of cell if it meets two conditions - I found an issue. need help
Conditional formatting.
I need to apply two conditions to turn a cell to red and should applicable for a range:
- If any cell from a range misses due date AND
- If that particular cell of that range has value "1"
THEN ONLY THAT PARTICULAR CELL SHOULD BE "RED"
Now it does work if you use below format. problem is its only taking one cell at a time particularly for "value". example '1"
For due date the entire range works fine if i remove the 2nd condition
=AND($K$40
Ok so still not 100% clear
Ok so still not 100% clear here as the function is only partial so won't do anything as far as I'm aware.
Where is your due date held? is it in a certain column and changes for each row of data or in a fixed cell and is the same for all in your array?
Cells that have the value 1, are these potentially the same cells that will have a date instead depending on the row? and if so again are they in any particular column of your array?
I'm trying to gauge if you want a row highlighted that meets both conditions, or stand alone cells that meet either of them.
Hi Arif
It appears some of your query has been cut off. Can you please supply the actual code you are using for your conditional formating? or better yet upload a sample spreadsheet
Regards
Mark
=AND($K$39
=AND($K$39but i face problem if want to set a range for value 1