Sean15
Well-known Member
- Joined
- Jun 25, 2005
- Messages
- 719
- Office Version
- 2010
- Platform
- Windows
Hi:
I want to do a conditional format based on the following:
If value in range A2:A60 is equal to 1301, or 1305, or 1306, or 1307, format corresponding value in range F2:F60.
So if A2=1301, format F2
If A2=1320, no format in F2
Could someone help with a formula please?
Regards,
Sean
I want to do a conditional format based on the following:
If value in range A2:A60 is equal to 1301, or 1305, or 1306, or 1307, format corresponding value in range F2:F60.
So if A2=1301, format F2
If A2=1320, no format in F2
Could someone help with a formula please?
Regards,
Sean