| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
if every cell is larger than x, but ignoring blank cells
Good Morning,
I have a variable row of cells (usually 8-12, but as long as 25). I just want a check that every cell that has a value in it has a value larger than 5. I started with =IF(AND(G12:O12=5),"Yes","No"), but if any cell is blank this doesn't work. How can I apply this to only cells within that range which have data entered? Thanks, Phillip |
|
#2
|
|||
|
|||
|
Quote:
If cell value is less than 5, turn the cell background grey. Just a thought. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ignoring blank cells | Excel Discussion (Misc queries) | |||
| Ignoring blank cells | Excel Discussion (Misc queries) | |||
| Ignoring blank cells on getting an average | Excel Discussion (Misc queries) | |||
| Ignoring Blank Cells | Excel Worksheet Functions | |||
| Help with ignoring blank cells | Excel Discussion (Misc queries) | |||
Linear Mode
