How to grey and/or block out cells under a set of conditions

[jinkies]

Hi! I have a spreadsheet that will be used to track data for multiple units and sometimes two of the units get combined. The spreadsheet will be shared, so I want it to be preset for anyone entering data. Would there be a way to grey out cells in a column based of a Y/N prompt? Example: If Y is entered in B2, how can I block data entry for C2,D2/entering N in B3, blocking E3?

 

[Joe4]

Welcome to the Board!

Yes, use Conditional Formatting.

Rule 1 (format columns C and D):
1. Select cells C2:D14
2. Go to Conditional Formatting
3. Select the New Rule option
4. Choose the "Use a formula to determine which cells to format" option
5. Enter the following formula:

=$B2="Y"

6. Click on the Format button
7. Go to the Fill tab
8. Select the gray color you desire
8. Click OK twice

Rule 2 (format column E):
1. Select cells E2:E14
2. Go to Conditional Formatting
3. Select the New Rule option
4. Choose the "Use a formula to determine which cells to format" option
5. Enter the following formula:

=$B2="N"

6. Click on the Format button
7. Go to the Fill tab
8. Select the gray color you desire
8. Click OK twice

This should do what you want.