I have created a table in Excel and the input is going to be one of the characters, whether it is possible to format the table, If the letter is input, then the cell automatically turns into a specified color ???
Thank you, sorry that this question is not the right place to keep it.
Yes, you use conditional formatting.
We have your table in A1: Click on G5 conditional formatting, select 'Highlight cell rule' and 'Equal to ...'.
Enter the highlight which you want to highlight and select Highlight from the dropdown button.
No comments:
Post a Comment