Forum Discussion
Ramu2603
Jan 22, 2024Copper Contributor
Require small help on "Conditional Formatting"
Hello Community, Have prepared an excel sheet where I keep track of ongoing projects. To make it little more interactive I made three conditional formatting rules which ...
- Jan 22, 2024
Hi Ramu2603
You should format your data as a Table this will allow formulas to auto-adjust as you add new rows:
Then, with the above Table set the following Cond. Format formulas (no $ after $M😞
Lorenzo
Jan 22, 2024Silver Contributor
Hi Ramu2603
You should format your data as a Table this will allow formulas to auto-adjust as you add new rows:
Then, with the above Table set the following Cond. Format formulas (no $ after $M😞
Ramu2603
Jan 22, 2024Copper Contributor
Many thanks @Lz,
This table trick worked.,
Thanks & Regards,
Ram
This table trick worked.,
Thanks & Regards,
Ram