Forum Discussion
Solved
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 ...
Hi Ramu2603
You should https://support.microsoft.com/en-us/office/format-an-excel-table-6789619f-c889-495c-99c2-2f971c0e2370 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😞
One more request, how do I use this 3 sets of conditional formatting for other Columns as well. For Example I want the cells to change color for Column B,C,D,E respectively
For Example I want the cells to change color for Column B,C,D,E respectively
Update the Applies To ranges:
PS: When you get a solution, there's a Mark as response at the botton that helps people who Search - Thanks
- Thanks once again @Lz, please correct me if I am getting it wrong. "Applies to = $B$4:$E$4", with this condition changes will get applied to only 4th cell of Column B to E.
Whereas my intention is to apply the coloring condition to all cells from $4 to $500 of Column B to E.
I hope you got what I am trying to convey- Please carefully review the picture I posted. It doesn't say "Applies to = $B$4:$E$4"