Conditional Formatting Throughout

In conditional formatting, I have

=$A$5=”x” (Formats the target cells to Fill Green) Applies to =$B$5:$T$5

This causes cells B5 through T5 to highlight green if cell A5 is x.

I’m using this to highlight work orders that have been completed in my work schedule. If the job is complete, I put an x in the first cell of the row and it highlights all the cells in that row up to cell T5.

Is there a way to use this for the entire document or even 50 rows without having to create a new rule for every single row I want to use it for?

By: Travis

Leave a Reply

Your email address will not be published. Required fields are marked *