We’re rewarding the question askers & reputations are being recalculated! Read more.

New answers tagged

0

how about you create another column and concatenate A and C, then do this: =Countif(D:D,D1)>1 When you concatenate serial and pass/notpassed you have a unique value for serial A-pass and serial A-"not passed" and then you can countif them


1

This should do the trick: and(today()>start_date,today()<end_date)


0

use find insteand of countif =find(B1,B:B)>1 Find returns how many times it finds a string in the text or cell value


0

Actually you have to translate your liking to formula: "I wanna highlight any cell in column red, yellow and green which is empty AND has an id on the id column" So it's or (red,yellow,green) and (id) *logic You can try building the formula in a cell and see if it returns true when all conditions are met and false when they aren't Say the columns are A,B,C ...


1

In the end =COUNTIF($B1:$B100,"month")>1 worked, no quotation marks. I thougth I tried it before


0

In your formula you have to omit the >1. Your Conditional Formatting formula should be: =COUNTIF($B1:$B100,"month") (The answer provided is in relation to your info. There is vital info missing from your question. I am not sure what exactly you try to achieve. Play around with the $ sign as well as the range and see your different results. Next time ...


0

One workaround is to use Google Apps Script instead of the built-in conditional formatting options but it doesn't performs so efficiently. References https://developers.google.com/apps-script/guides/sheets Related Question with the larger score so far How can I set conditional formatting on a particular cell that depends on another cell's value? ...


1

I think the relative and absolute reference would help you with this. There are 3 types of them: $A1 Allows the row reference to change, but not the column reference. A$1 Allows the column reference to change, but not the row reference. $A$1 Allows neither the column nor the row reference to change. In your case, I think you only want the column ...


1

The formula you need is the following: =NOT(ISBLANK($H3))*(ISBLANK(I3)) Please pay attention to the $ sign in front of H3. Using the $ (dollar) sign we "lock" the column and the formatting is being applied on the whole row. You apply the formula on the range I3:AA.


1


Top 50 recent answers are included