Task In Excel

Ayush_Jadli 

To apply the conditional formatting formula only to rows where the value is in uppercase, you can modify the formula to check the case of the text in Column A before applying the formatting. Here are the steps:

Step 1: Conditional Formatting for Bank Name (Column A):

1. Select the range of rows you want to apply formatting to, starting from the first row with uppercase text and light gold fill color.
2. Go to the "Home" tab, click on "Conditional Formatting," and choose "New Rule."
3. Choose "Use a formula to determine which cells to format."
4. In the formula bar, enter the following formula to check if the Bank Name in the current row (Column A) matches the Bank Name in the first row (let's say the first row is row 2) and if the text in Column A is in uppercase:

=AND($A2=$A$2, EXACT($A2, UPPER($A2)))

This formula checks both if the Bank Name matches the first row and if it's in uppercase.

1. Click on the "Format" button and set the formatting style you want (e.g., Light Green background). Click "OK" to confirm.

This modified formula will apply formatting only to rows where the Bank Name in Column A matches and is in uppercase. It ensures that the formatting is applied selectively based on your criteria. You can then create additional rules for other columns, if needed, following a similar approach.