This is a discussion on Conditional formatting within the Microsoft Office support forums, part of the Tech Support Forum category. OK, I have pondered this for two days; it so simple I'm ready to scream that I can't get it.
OK, I have pondered this for two days; it so simple I'm ready to scream that I can't get it. I have Sheet 1,column A, company name. In Sheet 2, Column A, I want to enter company name. If it is not in Sheet 1, column a (a table, as is sheet 2) I want the cell to turn red. So simple. Why can't I figure it out?
I assume you are using Excel. This works in Excel 365.
In Sheet 2 cell A1 enter =IF(ISBLANK(Sheet1!A1), "",Sheet1!A1)
Select that cell, and on the Home menu click 'Conditional formatting'
Click 'Highlight cell rules', 'More Rules', select 'Blanks' in 'Format only cells with"
Click 'Format' and select the Red color.
If there is a value in Sheet1!A1 it will appear in Sheet2!A1, otherwise Sheet2!A1 will be Red.
Works for me.
On re-reading your post I believe I may have misinterpreted your question.
Do you want to compare what you enter into Sheet2!A1 with Sheet1!A1, and if it is different, format Sheet2!A1 with Red text? If so:
1. Select Sheet2!A1
2. On the Home menu click 'Conditional Formatting'
3. New Rule
4. Select 'Format Only cells that Contain'
5. First drop-down - leave as 'Cell Value'
6. Second Drop-Down: Select 'Not equal to'
7. In the next field type = Sheet1!$A$1
8. Click 'Format' and select the desired colors for Font, Fill, etc
9. OK OK
I think I asked it badly. Sheet one is the customer information. the purpose of sheet 2 is to enter orders. Mae beauty salon gets contact infor in sheet 1. to put in a placed order in sheet 2, I need to be sure the salon has it contact info in sheet 1. if not, the sheet 2 cell should turn red to alert the input person that she needs to enter the db info in sheet 1. I will try your second suggestion. Appreciate the input.
I just want to be sure that orders entered are done so with companies established in the DB. The invoice picks off address and so forth from DB. Then, it gets order info, amounts, paid, etc. from the order input sheet.
Have no particular reason to build this. I started it to learn more about dynamic arrays. I am a hobbyist.