Need a cell to change colour if another cell has an 'x
Closed
Martin
-
Jan 12, 2016 at 03:41 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Jan 12, 2016 at 06:30 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Jan 12, 2016 at 06:30 AM
Related:
- Need a cell to change colour if another cell has an 'x
- If cell contains text then return value multiple conditions ✓ - Excel Forum
- Crimping colour code - Guide
- Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum
- If cell contains date then return value ✓ - Excel Forum
- Excel "IF" function w/ date in test cell ✓ - Excel Forum
1 response
vcoolio
Posts
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
Jan 12, 2016 at 06:30 AM
Jan 12, 2016 at 06:30 AM
Hello Martin,
Conditional formatting is all you need:-
- Click on cell R13.
- In the ribbon at the top of your sheet, select Conditional Formatting then select New Rule.
- From the dialogue box that appears, select " Use a formula to determine which cells to format".
- In the "Format values where this formula is true" box, type in the following formula:-
=R14="x"
- Click on the Format button and from there select your format colour as green and click OK.
- Click OK again on the next dialogue box to appear.
- Done!
Cheerio,
vcoolio.
Conditional formatting is all you need:-
- Click on cell R13.
- In the ribbon at the top of your sheet, select Conditional Formatting then select New Rule.
- From the dialogue box that appears, select " Use a formula to determine which cells to format".
- In the "Format values where this formula is true" box, type in the following formula:-
=R14="x"
- Click on the Format button and from there select your format colour as green and click OK.
- Click OK again on the next dialogue box to appear.
- Done!
Cheerio,
vcoolio.
