-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Conditional Formatting
- Thread starter Donald
- Start date
Scott Huish
MrExcel MVP
- Joined
- Mar 17, 2004
- Messages
- 20,336
- Office Version
- 365
- Platform
- Windows
In Conditional Formatting, change Cell Value is to Formula Is and use the following formula:
If you don't want it to format if A1 was blank, then perhaps:
Code:
=$A1<100If you don't want it to format if A1 was blank, then perhaps:
Code:
=($A1<100)*($A1<>"")
Upvote
0
