Seelct cells you want to format and write in Conditional Formatting:
=$H2="Finished"
Seelct cells you want to format and write in Conditional Formatting:
=$H2="Finished"
Never use Merged Cells in Excel
Thanks guys!
Thats now changed the formatting for the individual rows that have a status of finished but is there a way I can get it to only flag if every row for that client is at 'Finished' in column H. I highlighted Column B, added conditional formatting and insterted the =$H2="Finished" in the formula section
Sorry I'm liking being a divvy, really appreciate the advice!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks