Hi There,
A couple of questions.
1) I have created a rule for conditional formatting and wish to copy this to other cells. I have used the Format Painter but does not do what I need it to do.
Rule 1) If Cell Value is greater than N2 highlight Green.
Rule 2) If cell Range is between L2 & M2 Highlight Red
I want to create the same rule but in row 3 I want it to look at L3, M3 & N3 not N.
How can I do this for all rows without manually doing each 1?
2) I have a custom Cell [h]:mm;@. I want to convert this in to standard text / numbers.
For example the numbers in the custom Cell are 168:43, i want this to be displayed in another cell as 168.43. Or 149:23 to 149.23.
I was hoping to use a simple formula like =F2 (where the customer cell is) and it would just convert it.
A couple of questions.
1) I have created a rule for conditional formatting and wish to copy this to other cells. I have used the Format Painter but does not do what I need it to do.
Rule 1) If Cell Value is greater than N2 highlight Green.
Rule 2) If cell Range is between L2 & M2 Highlight Red
I want to create the same rule but in row 3 I want it to look at L3, M3 & N3 not N.
How can I do this for all rows without manually doing each 1?
2) I have a custom Cell [h]:mm;@. I want to convert this in to standard text / numbers.
For example the numbers in the custom Cell are 168:43, i want this to be displayed in another cell as 168.43. Or 149:23 to 149.23.
I was hoping to use a simple formula like =F2 (where the customer cell is) and it would just convert it.