Godders199
Active Member
- Joined
- Mar 2, 2017
- Messages
- 313
- Office Version
- 2013
Hello, before i start rebuilding a spreadsheet to split values into two cells, is there anyway to conditionally format a cell, based on one of the values contained in it. for example
<colgroup><col width="74" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2706;">
<col width="115" style="width: 86pt; mso-width-source: userset; mso-width-alt: 4205;">
<col width="89" style="width: 67pt; mso-width-source: userset; mso-width-alt: 3254;">
<tbody>
</tbody>
the formula in the cell, counts occurance an then calculates the percentage.
all am looking to do is say if cell %> X then format red for example.
If not i will just split the formula into 2 cells and format both.
11(78.6%) | 2(14.3%) | 1(7.1%) |
the formula in the cell, counts occurance an then calculates the percentage.
all am looking to do is say if cell %> X then format red for example.
If not i will just split the formula into 2 cells and format both.