1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Conditional formatting highlighting row below targeted cell

Hello everyone, I am new to needing to use excel but I was put into a position where we use a table to highlight tasks that are "open, closed, overdue, in progres, or overdue." Now the issue is with 20 other people who have access to this the rule that was made has been broken and is not selecting the whole row or it is selecting the row below. The column with this info is in H. The first three rows are used for headers and then from the 4th row down is what is supposed to be targeted. When I put in the rule =$H4="Open" and then apply it to the table it make row 5 turn to the color not row 4. Only other thing is the table is about 3000 rows long so maybe I am messing something up but I just started using excel last month.

submitted by /u/0341joker
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#row zero
#Excel alternatives for data analysis
#rows.com
#Excel compatibility
#financial modeling with spreadsheets
#natural language processing for spreadsheets
#generative AI for data analysis
#conditional formatting
#Excel
#highlight
#open
#rule
#row
#table
#overdue
#tasks
#closed
#column
#in progress
#cell