SSRS report - conditional reporting after exporting to excel?

Question

I have built a SSRS report where I have left the first column of a table empty. I want every cell in this column to be conditionally formatted so that it changes to red fill whenever I type in "r" in one of these cells AFTER exporting it to excel. Can I do this directly in the report builder? Any help is appreciated. Thank you guys !

Answer 1

The way you do it is by using "Use a Formula to Determine which cells to format" option in "Edit Formatting Rule". Let's say you have column A where you need this formatting done. Also, the range of cells that need formatting are A2:A10. Go to cell A2. Navigate to "Home->Conditional Formatting->Highlight Cells Rules->More Rules->"Use a Formula to Determine which cells to format->Format Values where this Formula is true". Enter =$A2="R". Click "Format" and select the formatting you need for the cells that contain "R". Click OK and then another OK. The second step is to keep the cursor on A2 and go back to "Conditional formatting->Manage Rules". You will see the Conditional Formatting Rules Manager. In the applies to put your range. $A$2:$A$10. And click Apply->OK. If you did this you should see all the cells that have the value "R" show the formatting you needed. Hope that helps