Very simple: For every row I need this:And I need that for every row in the sheet. I'm up to 65 rows and it is expected to grow into the hundreds. Currently, I have to build those two rules custom for each new row of data, and that's going to get old real fast...
- If C2<B2, then C2 needs to be in red
- If C2>B2, then C2 needs to be in green
Select all of the cells currently formatted with Conditional Formatting and clear them.
Convert your data table into and Excel Table
Select *ALL* of the rows/cells currently in the table, then re-apply the Conditional Formatting.
Excel will carry all formatting and formulas to news rows of data.
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks