Conditional Formatting for a particular column

Solved/Closed

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

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?
Change the youtube video category - Guide
Excel clear formatting - Guide
Microsoft office accounting software - Download - Billing and accounting
What is mp3 format - Guide
Based on the values in cells b77 b88 ✓ - Excel Forum

5 responses

Réponse 1 / 5

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

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 27 April 2015 Status Member Last seen 30 April 2015
29 Apr 2015 à 06:30

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 27 April 2015 Status Member Last seen 30 April 2015
29 Apr 2015 à 06:30

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

Réponse 2 / 5

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

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

Harish51290 Posts 5 Registration date Monday 27 April 2015 Status Member Last seen 30 April 2015
27 Apr 2015 à 23:25

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 3 March 2015 Status Moderator Last seen 3 July 2015 69
28 Apr 2015 à 06:50

what are the conditions?

Harish
28 Apr 2015 à 23:13

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.

Réponse 3 / 5

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

try this:

I tried it and it's working

Réponse 4 / 5

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

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.