Forum Discussion

Georgie13's avatar
Georgie13
Copper Contributor
Sep 15, 2022
Solved

Conditional Formatting Excel Online

I'm trying to use conditional formatting on column A in sheet1 to highlight any cells that have the same data as any of the cells in column A in sheet2.    I've tried using =COUNTIF('sheet2'!$A:$A)...
Excel for web
  • DexterG_III's avatar
    DexterG_III
    Sep 15, 2022

    Georgie13 Please make sure the Rule Type is set to "Formula" and use the following function in the formula input box as shown below.  

     

    =ISNUMBER(MATCH(A1,Sheet2!$A:$A,0))

     

    Hope this helps,

    Dexter

     

dscheikey's avatar
dscheikey
Bronze Contributor
Sep 15, 2022

Georgie13 

The Countif command has two parameters.

=COUNTIF(Where do you want to look?, What do you want to look for?)

In addition, with conditional formatting you must always produce a TRUE or FALSE result. For example, COUNTIF(A:A, "YES")=5

 

 

Resources