Tatsukejpi

 Hi all, I want to count cells that contain specific text but multiple criteria For example in range B4B12 I want to count the cells that contain the word 'daily' AND the word 'weekly' Each cell in the range contains one word thank youHow to use the SUMPRODUCT function in Excel Returns the SUM after multiplication of values in multiple arrays in excel COUNTIFS with Dynamic Criteria Range Count cells depstartent on other cell values in Excel COUNTIFS Two Criteria Match Count cells matching two different criteria on list in excelCOUNTIFS function Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 19 Excel 16 Excel 19 for Mac Excel 13 Excel 10 Excel 16 for Mac Excel Web App More Less The COUNTIFS function applies criteria to cells across multiple ranges and counts the number of times all criteria are met How To Use Multiple Criteria In Excel Countif And Countifs How do i use countif with multiple criteria

 I have a question on conditional formatting based on another cell's color Say for example, cells to A5 are grouped with A1 being the parent to A5 is either green or red and if any of those 4 cells are red then the parent, A1, needs toIn case you prefer reading written instruction instead, below is the tutorial Conditional Formatting allows you to format a cell (or a range of cells) based on the value in it But sometimes, instead of just getting the cell highlighted, you may want to highlight the entire row (or column) based on the value in one cell Instead of using a formula, you should go with conditional formatting Select the appropriate column and go to Home > Conditional formatting > Highlight Cells Rules Afterwards you can define the criteria, and which color the cell should become For a more extensive explanation, visit the following link Conditional Formatting Based On Dates In Excel Microknoweldge Inc How to get a cell in excel to change color based on date ...