Excel

Highlighting Rows

select the rows to be highlighted
Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format
use the formula '=MOD(ROW(),3)=0'(this checks if the row number is divisible by 3)
Click on 'Format', choose your desired highlight color, and then click 'OK'

=COUNTIF($A$1:$A$10, A1)>1 (highlights duplicate values in a range)
=B1>10 (highlights cells in column A if the corresponding cell in column B is greater than 10)
=$A1="Specific Text" (highlights the entire row if a cell in column A contains "Specific Text")
=A1>100 (highlights cells that are greater than 100)
=AND(A1>=DATE(2024,1,1), A1<=DATE(2024,12,31)) (highlights dates within the year 2024)
=ISNUMBER(SEARCH("text", A1)) (highlights cells that contain the word "text")
=AND(A1>=10, A1<=20) (highlights cells where the value is between 10 and 20)
=A1>B1 (Highlights cells in column A that are greater than the corresponding cell in column B)
=ISBLANK(A1) or =NOT(ISBLANK(A1)) (highlights rows based on whether a cell in column A is blank or not)
=OR(WEEKDAY(A1)=1, WEEKDAY(A1)=7) (highlights cells containing dates that fall on weekends)