I have a sheet same as the attached excel file; I need to apply conditional formatting to it.
Can u please tell me the steps in excel how to apply conditional formatting for this data using a formula.
My Problem is:
In the excel sheet,
If Column A is not equal to “ENTRY “then values in the following columns should be displayed in WHITE .The columns are:
1. User id
2. Approver id
4. Date that user input entry
5. Effective date of entry
I.e. column A with values “GRRLINES” and “lines”, the values in the above columns mentioned should b in WHITE
If column A is equal to “ENTRY” then those values should be in BLACK in the same above columns mentioned
1. Here we can give a range in top range corner of the excel sheet
2. We can apply the formula
Can u please help me with the steps to apply the formula as soon as possible. Please help me in this problem