Conditional Formatting for 2 columns
Closed
NicA81
-
Mar 1, 2016 at 10:12 AM
BrianGreen Posts 1010 Registration date Saturday January 17, 2015 Status Moderator Last seen September 30, 2021 - Mar 4, 2016 at 09:52 PM
BrianGreen Posts 1010 Registration date Saturday January 17, 2015 Status Moderator Last seen September 30, 2021 - Mar 4, 2016 at 09:52 PM
Related:
- Conditional Formatting for 2 columns
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Plants vs zombies 2 pc download - Download - Strategy
- Five nights in anime 2 - Download - Adult games
- Conditional formatting if another cell contains any text ✓ - Excel Forum
- Conditional format based on another cell containing text - Excel Forum
1 reply
BrianGreen
Posts
1010
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
September 30, 2021
150
Mar 4, 2016 at 09:52 PM
Mar 4, 2016 at 09:52 PM
Hi NicA81,
You could try adding another Conditional formatting rule to the date cell:
1. Select the date cell you want to conditional format.
2. Click Conditional Formatting from the top ribbon.
3. Select New Rule.
4. Click "Use a formula to determine which cells to format".
5. In the "Format values where this formula is true" section type =[addess od cell you have a Y in]=Y=TRUE
6. Click the [Format] button followed by the "fill" tab and select a shade of highlight you like.
7. Click the [OK] button and again click the [OK] button.
8. Finally put a tick in the "Stop if true" boxes at the end of each line and then click the [OK] button.
Hopefully you will now have what you need. Please let me know how you get on.
You could try adding another Conditional formatting rule to the date cell:
1. Select the date cell you want to conditional format.
2. Click Conditional Formatting from the top ribbon.
3. Select New Rule.
4. Click "Use a formula to determine which cells to format".
5. In the "Format values where this formula is true" section type =[addess od cell you have a Y in]=Y=TRUE
6. Click the [Format] button followed by the "fill" tab and select a shade of highlight you like.
7. Click the [OK] button and again click the [OK] button.
8. Finally put a tick in the "Stop if true" boxes at the end of each line and then click the [OK] button.
Hopefully you will now have what you need. Please let me know how you get on.