HOWTO: What is the formula to have evaluate a range of value
Hi Apache007
If I've understood correctly, you want to highlight cells in A1:A100 which
are not empty and contain a value between 5 and 20 using Conditional
Formatting.
To achieve this, you only need one criteria - Go into Conditional Formatting
and set the following:
Condition 1
Cell Value Is between 5 and 20
and then obviously set the highlighting you want under the Format button.
You don't need to check for non-blank cells as a blank cell simply fails to
meet the requirement of being between 5 and 20.
Hope this helps.
"apache007" wrote:
Hi All,
Let say I have data Coloum A1:A100 containes number data
and I want to HIGHLIGHT using Conditional Formatting, those cells that have
the following criteria:
1. Is not empty
2. Has a value between 5 and 20.
I don't know the formula for Criteria #2.
Thanks.
|