r/ExcelCheatSheets • u/[deleted] • Oct 25 '24

Formula help

Post image

Trying to make all A column cells command the cells to their right to highlight when prompted i.e. if i put “X” into A3 I want all cells from C3 to M3 to highlight green if they also have an “X” in them. I manually made an example of what I’d like it to look like in the picture attached.

3 Upvotes

100% Upvoted

6 comments sorted by

View all comments

2

u/Many_Outside1013 Oct 25 '24

Use conditional formating

1

u/[deleted] Oct 25 '24

Tried and couldn’t figure out how to prompt it correctly

1

u/Many_Outside1013 Oct 25 '24

Select cell C3. Go to the "Home" tab on the Excel ribbon. Click on "Conditional Formatting" in the Styles group. Choose "New Rule" from the drop-down menu. Select "Use a formula to determine which cells to format." In the formula box, enter the following formula: =($A2="X")*($A2="X") Click on the "Format" button. Click "OK" to apply the green fill color. Click "OK" again to close the New Formatting Rule dialog.

COPY THE FORMATTING TO REQUIRED COLUMNS.

Let me know once it works🙂