Steve 1962
Active Member
- Joined
- Jan 3, 2006
- Messages
- 351
- Office Version
- 365
- Platform
- Windows
I have values in A1 and B1 and values in C1 and D1.
If the count of values in C1 & D1 (can be either 0, 1 or 2 as there are only two colums) does not equal the count of values in A1 & B1 (can be either 0, 1 or 2 as there are only two colums), then I need to conditional format (TRUE) in cell A1 and B1.
Thanks
If the count of values in C1 & D1 (can be either 0, 1 or 2 as there are only two colums) does not equal the count of values in A1 & B1 (can be either 0, 1 or 2 as there are only two colums), then I need to conditional format (TRUE) in cell A1 and B1.
Thanks
Last edited by a moderator: