Conditional formatting.

Hello Sandip,

Hope you enjoyed your Microsoft Excel Intermediate course with Best STL.

Thank you for your question regarding how to use conditional formatting for an entire row.

First of all you need to determine what the condition will be then enable the formatting if this condition is true. To do this you must first select the range where the conditional formatting will be required. The range can include several columns of data. Then click the Conditional Formatting button and choose the appropriate condition/formula followed by the formatting required. Click OK to complete. The data should now reflect the formatting as required.

I have attached a file reflecting this type of conditional formatting which you may find useful.



I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.

Regards,


Rodney
Microsoft Office Specialist Trainer