Need a cell to change colour if another cell has an 'x
Closed
Martin
-
Jan 12, 2016 at 03:41 AM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Jan 12, 2016 at 06:30 AM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Jan 12, 2016 at 06:30 AM
Related:
- Need a cell to change colour if another cell has an 'x
- Crimping colour code - Guide
- How to change free fire google account to another google account - Guide
- Change computer name cmd - Guide
- If cell contains date then return value ✓ - Excel Forum
- Excel "IF" function w/ date in test cell ✓ - Excel Forum
1 response
vcoolio
Posts
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
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.
