Conditional Formatting for a particular column

Solved/Closed

Harish - Apr 27, 2015 at 03:42 AM
Harish51290 Posts 5 Registration date Monday April 27, 2015 Status Member Last seen April 30, 2015 - Apr 30, 2015 at 12:00 AM

Hello,

I need to perform conditional formatting on a particular column, which should display the numbers entered into it, in 3 decimal format.

Please provide the solution.

Thanks in Advance,
Harish

What is true about formatting cells to a particular category, such as accounting or currency?
Microsoft office accounting - Download - Billing and accounting
How to change free fire facebook account to google account - Guide
How long does facebook take to review disabled account - Guide
Clear only the formatting from the selected cell (leaving the content) - Guide
Based on the values in cells b77 ✓ - Excel Forum

5 responses

Answer 1 / 5

MaxStart Posts 338 Registration date Tuesday March 3, 2015 Status Moderator Last seen July 3, 2015 69
Apr 29, 2015 at 05:51 AM

you can gather your conditions as rules;
select the column you want

go to Home tab at the ribbon and choose Conditional Formatting

add another rule:

you can see all the rules you created by going to Manage Rules

Harish51290 Posts 5 Registration date Monday April 27, 2015 Status Member Last seen April 30, 2015
Apr 29, 2015 at 06:30 AM

Its not working with "Format only cells that contain", but when I tried with "use a formula to determine which cells to format", only first cell gets the change in precision, out of all the selected cells.

Harish51290 Posts 5 Registration date Monday April 27, 2015 Status Member Last seen April 30, 2015
Apr 29, 2015 at 06:30 AM

Also I used the formula as =D1="ABCD", not "ABCD"

Answer 2 / 5

MaxStart Posts 338 Registration date Tuesday March 3, 2015 Status Moderator Last seen July 3, 2015 69
Apr 27, 2015 at 04:16 AM

you don't need conditional formatting to do that
select the column - right click and choose format cells

Harish51290 Posts 5 Registration date Monday April 27, 2015 Status Member Last seen April 30, 2015
Apr 27, 2015 at 11:25 PM

Hi Max,

My requirement is such that, there are 5 columns,and for each column I have a condition, on this condition precision has to change.

MaxStart Posts 338 Registration date Tuesday March 3, 2015 Status Moderator Last seen July 3, 2015 69
Apr 28, 2015 at 06:50 AM

what are the conditions?

Harish
Apr 28, 2015 at 11:13 PM

My Condition is such that, a cell say example : E5, has some product name "ABCD", based on this text, column of say for example 50cells, has to display the data entered into it in decimal format, for example : 5 decimal places....If the product name differs, the decimal format has to change as per the product.. Product is an electronic product, each product provides output in decimal format.

Answer 3 / 5

MaxStart Posts 338 Registration date Tuesday March 3, 2015 Status Moderator Last seen July 3, 2015 69
Apr 29, 2015 at 07:38 AM

try this:

I tried it and it's working

Answer 4 / 5

Harish51290 Posts 5 Registration date Monday April 27, 2015 Status Member Last seen April 30, 2015
Apr 29, 2015 at 07:59 AM

Hi, my requirement is to change the precision for different values entered in to 50 cells.

In the screenshot, you can see, text "Singleday Infusor", this is in cell D1, so I'm using formula as =D1="Singleday Infusor".

Also you can see the columns, Ave.Cor, Flow Rate & Out of limit, these columns should display the entered values in different precision(3decimals, 4decimals etc), but for the attached case, its 3 decimals.

Based on the text in cell D1, the columns should get updated with required precision.

For, Singleday Infusor -3 decimals.
For, Halfday Infusor - 4 decimals.

Here we take, output of 50 samples from each device and have to enter in the columns mentioned above in the respective decimal format for each device.

Answer 5 / 5