Here are some problems that our users have asked and received explanations on
Hello, I need that a conditional format formula is canceled when another one is true. The first formula is when the value of the cell is not between this two number, and the other one is this =AND($A2<>"REF",$B2<>"REF")
Solved by G. J. in 23 mins
I am currently trying to get the "IFS" formula to return multiple values (Text strings) into one cell, the issue i am having is its only returning the first "true" value and not ALL the true values into one cell. Can this be done?
Solved by F. H. in 14 mins
I am looking for a formula to validate a cell content to a "A expected Match" and return true or false. Format: xx-yy XX - Numbers (this is dynamic) YY - Text (this is as per defined) *No space should be there before or after the hash, but between the text is fine Sample True: 4-ABC 7-BCA
Solved by V. U. in 27 mins
I have conditional formatting in a cell = xx<xx format the cell green. I would like to add if this is true, display the following "text". What formula would I use?
Solved by E. B. in 17 mins
I need a formula that will produce an error alert if the value of a cell is TRUE in the Data Validation dialogue box under the settings tab. For reference, in conditional formatting, I would use the formula =E$6$=TRUE to check if the cell value is true and format the cell accordingly. This results in the standard "There's a problem with this formula." message when used in the Data validation box.