Cell format
Solved/Closed
mastachaah
Posts
2
Registration date
Sunday 15 March 2015
Status
Member
Last seen
17 March 2015
-
16 Mar 2015 à 02:25
MaxStart Posts 338 Registration date Tuesday 3 March 2015 Status Contributor Last seen 3 July 2015 - 17 Mar 2015 à 12:13
MaxStart Posts 338 Registration date Tuesday 3 March 2015 Status Contributor Last seen 3 July 2015 - 17 Mar 2015 à 12:13
Related:
- Cell format
- Dvi format - Guide
- Kingston format utility - Download - Storage
- Hdd low level format tool - Download - Storage
- Hp usb disk storage format tool - Download - Storage
- How to change date format in excel - Guide
1 response
MaxStart
Posts
338
Registration date
Tuesday 3 March 2015
Status
Contributor
Last seen
3 July 2015
69
16 Mar 2015 à 22:23
16 Mar 2015 à 22:23
OK, the answer to your issue is Conditional formatting
I've made an example for you
Cell A1 will contain the drop-down list witch contains the following
%
RM
Date
now Cell B1 will change format according to cell A1 value
just write anything in cell B1 to see resauts
1- go to Conditional formatting and choose new rule
2- now you need to select the drop-down litst cell entering the following formula
=$A$1="%"
3- now go to the format button and choose the percentage format and maybe change the fill color for differentiation.
4- click ok.
5- repeat steps from 1 to 4 for each value in the drop-down list just change the conditions accordingly
=$A$1="%"
=$A$1="RM"
=$A$1="Date"
6- now go to conditional formatting and choose manage rules
7- change the targeting rules accordingly
this should work just fine.
feed us back if it woks for you.
I've made an example for you
Cell A1 will contain the drop-down list witch contains the following
%
RM
Date
now Cell B1 will change format according to cell A1 value
just write anything in cell B1 to see resauts
1- go to Conditional formatting and choose new rule
2- now you need to select the drop-down litst cell entering the following formula
=$A$1="%"
3- now go to the format button and choose the percentage format and maybe change the fill color for differentiation.
4- click ok.
5- repeat steps from 1 to 4 for each value in the drop-down list just change the conditions accordingly
=$A$1="%"
=$A$1="RM"
=$A$1="Date"
6- now go to conditional formatting and choose manage rules
7- change the targeting rules accordingly
this should work just fine.
feed us back if it woks for you.
17 Mar 2015 à 11:37
17 Mar 2015 à 12:13
just make thee Decimal places = 0