How to make one cell bold & color ????

Assuming the cells you want to color are A2:A100

1) Select cells A2:A100
2) Apply these conditional formatting settings:

-Use a formula
=ISNUMBER(A2)
Format ... bold (and choose color)

Yes it is possible.

Select the whole column and press ALT->O->D
You will get conditional formatting window -> New Rule->select use a formula to determine which cell to format->put formula =NOT(ISBLANK(A1))-> then click format and format the cell as you want.

That's it.

Hope it will help you

Perhaps =and(isnumber(A2),A2>1) as condition

Or

=AND(NOT(ISBLANK(A1)),A1>1)

I Shukla your formula would need to be:

=AND(NOT(ISBLANK(A1),A1>=1)

Originally Posted by shukla.ankur281190

Or

=AND(NOT(ISBLANK(A1)),A1>1)

The ISNUMBER condition is essential. Check your formula and you will see that a text string passes the test, therefore your solution might lead to errors ( especially in the case where a cell contains a null text string ("")

Why? Because before comparing values of cell contents, XL first compares their TYPE ( see that function). TYPE("text") returns 2 while TYPE ( number) returns 1.

So, if for any reason a cell contains text, it is always considered larger than a cell containing a number.

If the return of TYPE is the same, then XL will compare values as required in this case

(Don't ask why MS works this way. I can only say that in other suites like Libreoffice it is not the case)