how will you apply rules to cell A1 so that if you type any colour name from VIBGYOR SERIES, the cells fill colour changes to the Color?
Answers
Answer:
when you will dip in hyroxide acid we will dip the a special paper i don't know that name then it changes its color
Answer:
To apply conditional formatting rule to cell A1:
1. Select cell A1 and click on conditional formatting option in the home tab under styles group
2. A conditional formatting dialog box will appear
3. Click on Manage Rules option
4. Conditional Formatting Rules Manager will appear
5. Click on New Rule option
6. Select 'Format only cells that contain' Rule type
7. Choose 'Specific text' instead of 'Cell Value'
8. Add text 'Red' in the text box
9. Click on 'Format' button
10. A Format Cells dialog box will appear
11. Choose Red color in the fill tab and click ohk, again click on ok
12. Now, repeat the steps from '5' to '11', just name all the VIBGYOR series one by one instead of red
13. After doing that click on apply and then select ok