Originally Posted by
Logit
Example that can be done on any cell/row
Enter a 1 in cell C8
Left Click cell / Conditional Formatting / New Rule / Use A Formula To Determine Which Cells To Format
Paste this formula into the formula field =$C8=1
Click Format Color & choose color
Click Ok
Back at worksheet now -
Click cell C8 / Format Painter (on Home Tab)
Now have marching ants around C8
Click in A8 and hold / drag as far right as desired. Lift left mouse button.
All of row 8 now highlighted.
If you want to apply the same rule to other rows you can :
- highlight the row with color
- copy and paste to another row
or
- with the row highlghted, click and hold on the small button lower right corner
of highlighted area, then drag down as far as needed.
- anytime a 1 is entered into a cell in Column C, that row will be highlighted.
You can change the number 1 in the formula for anything that you are tracking which causes the row
to change color.
Bookmarks