Search results

The rule that I am looking for conditional formatting is 1. Column A has n. no.of values and Column B has n. number of values. 2. I want to apply conditional formatting on every cell of Column B which is driven by value in Column A and its corresponding value in Column B. The formula that I...

Hi, I am trying to create an IF function statement combining it with conditional formatting. My question is in 2 folds: 1. The formula that I am trying to create is If B2 = 'New' - check B3 = '0' (i.e.blank), if false then colour B3 with Red AND - check B4 = 'Tester', if false then...

Example: As per the table, the count of unique scripts executed should be 30. If I apply filter, on the Exec date for "today's date" and on the Status for 'Passed' and "failed". I get around 32 rows. So the count should be 32 for unique scripts executed. BUT.. there is 1 script in the...

The formula is supposed to give me the count of the Column 'Exec Date' where the status column has valued 'Passed' or 'Failed ' and 'Exec Date' value should be 'Today's date' Also there has to be one more loop to the above the formula. The column 'Plan Test Name' may have a value which may me...

hi Luke, Below is the link https://docs.google.com/open?id=0B3C0UEqCBRa1QlJXbVlXVFQ3WlU

I am looking for a formula with which I want to calculate the "Unique scripts executed" out of a chunk of data. Details: A script is executed if the 'status' column says Passed or Failed. A script is identified by its name shown in column 'Plan: Test Name' Unique scripts are one which are...

Hi Luke, Thanks for the reply! My apologies, I should have elaborated myself. Below is the way I have created my data. Cell A1= Today()-90 Cell A2= Today()-89 . . . Cell A90= Today() In such a case, how do I go about removing Weekends? Regards, RS

I am preparing test data for my testing...where in I have to play with dates I prepared the data with dates and used the TODAY() function with + and - thing to arrive at dates the problem now is that I want to remove the weekend days, sat and sun do you know of any formula which merges...