Apr 19, 2019 ... I am trying to highlight a cell if the text matches some text in a column of another sheet. I found a tutorial online which works but am not sure why the ...

Oct 6, 2020 ... =match(C2,indirect("data list!A2:A"),0). It does highlight the cell when it matches the value from the another sheet and I want it to highlight ...

Aug 11, 2020 ... I've got a simple sheet for scheduling an intensive study of French. Column C has due dates for each chapter. I've got a calendar to the right.

Nov 9, 2021 ... If your sheet is not too large, you can look at the CF i placed in column D. =(IsError(Match(A2, Indirect("Color!B2:B"), 0))) * (D2<>"").

Jun 21, 2019 ... Is there a way use conditional formatting to highlight values that match criteria in another sheet? ... Sheet #1, Column A into a calendar format.

Jul 10, 2019 ... Any update to this? I get the error stating that conditional formatting cannot reference another sheet.

Nov 17, 2021 ... The final choice in the real spreadsheet would be many, many rows over and coming in at random (imported from a google form). I want to ...

Nov 6, 2019 ... not sure if its possible to have dates highlighted according to another sheet. ... another beast from normal excel). I have also enabled ...

Dec 8, 2019 ... I have a tab Master that displays values using various formulas, mostly QUERY() and INDEX(QUERY()) functions based on values in another tab ...

Apr 30, 2019 ... The catch (apparently) is that I don't want to have to hand write this rule for each cell in my sheet, and then again for each cell for the 4 ...

Jul 13, 2021 ... You can hide column E or move it to the far right of the Overview sheet if you don't want to see it as part of your Overview table, but it needs ...

Jan 13, 2022 ... I have a sheet where I want it to compare and highlight each row here value in Column H doesn't match value in column I for each row in the whole sheet.

Mar 7, 2022 ... Hi, I have been trying to figure this out for a while and can't and it's super easy with Excel, but I can't do it in Google Sheets for some ...

Mar 18, 2019 ... ... highlight EXACT matches for a duplicate cell. So for each ... highlight the cell if a duplicate exists in another cell in the same column.

Sep 26, 2023 ... I am trying to write a conditional formatting formula for column 1 of "Sheet A" that searches column 2 of "Sheet B" for a matching registration number.

Sep 21, 2020 ... I have many tabs and I would like to highlight a cell if the name is from a player that I'm particularly interested in. And all the tabs have data filters for ...

Jan 1, 2021 ... To exempt the leaders from being highlighted, try this: =match(C4,query({index(indirect("FFA!C4:E7"),0,match(C$3,indirect("FFA!C3:E3"),0))}," ...

May 8, 2020 ... I want to be able to type a name and where ever that name is at in column C, I want it to be either highlighted a certain color or a strikethrough on the name ...

Apr 25, 2020 ... ... match another 6 cells in a different worksheet (Y3:Y8). Example: In the 1st worksheet, cells D13:I13: 4, 4, 6, 3, 6, 2. In the 2nd worksheet, ...

Dec 31, 2020 ... I have a Google Sheet called 'Food Planner 2' with two tabs, 'Magic Menu' and 'Reference Table'. In both tabs I have two matching columns: ...