Conditional Formatting

**Shermaine2010** · 07-08-2011, 05:15 AM

Hi all,

I wan greater than equal than 3 is show pattern RED. How to set Conditional Formatting if there have blank column, text and number. Text and number is get from formula.

Column as below.

Pay
3
(blank)
Pay
6

Thanks.

**Roger Govier** · 07-08-2011, 05:22 AM

Hi

Slect the range of cells to which the conditional formatting is to be applied (I have assumed they are in column A.

Format>Conditional Formatting>Formula is
=AND(ISNUMBER(A1),A1>=3)
Format>Fill Colour>Red

**Shermaine2010** · 07-08-2011, 05:32 AM

Originally Posted by Roger Govier

Hi

Slect the range of cells to which the conditional formatting is to be applied (I have assumed they are in column A.

Format>Conditional Formatting>Formula is
=AND(ISNUMBER(A1),A1>=3)
Format>Fill Colour>Red

If there is whole row, A1 should be put which one?

or A1 mean for wat?

**arthurbr** · 07-08-2011, 05:51 AM

Shermaine,
stop quoting as requested 3 times in your former post

**Shermaine2010** · 07-08-2011, 05:59 AM

arthurbr: no problem. new user. not sure how to use it.. This question did you know how to solve?

**brokenbiscuits** · 07-08-2011, 06:27 AM

A1 in this instance is the first cell in the range you wish to apply formatting for.

So if you wanted to format the range B6:D22, you would highlight this range and substitute A1 for B6 in the formula.