Pedro
asked on
Use a formula to apply conditional formatting in Excel
Hi everyone,
I would like to use conditional formatting in Excel to Bold certain cells based on their value.
I have tried to use excels built in conditional formatting function but it seems awkward to have to format every single cell since I am using different formatting rules for each cell. Then I would have to manually do this for the entire table, thus it becomes very cumbersome to do manually.
For instance, the attached file cells are to be formatted as follows:
Cell # Format Bold if ...
C6 ...................... greater than 0
D6 ...................... negative number
E6 ...................... negative number
F6 ...................... negative number
G6 ...................... negative number
H6 ...................... greater than 0
I6 ...................... greater than 0
Is there a formula for this formatting?
EE-CellFormatBasedonValue.xlsx
I would like to use conditional formatting in Excel to Bold certain cells based on their value.
I have tried to use excels built in conditional formatting function but it seems awkward to have to format every single cell since I am using different formatting rules for each cell. Then I would have to manually do this for the entire table, thus it becomes very cumbersome to do manually.
For instance, the attached file cells are to be formatted as follows:
Cell # Format Bold if ...
C6 ...................... greater than 0
D6 ...................... negative number
E6 ...................... negative number
F6 ...................... negative number
G6 ...................... negative number
H6 ...................... greater than 0
I6 ...................... greater than 0
Is there a formula for this formatting?
EE-CellFormatBasedonValue.xlsx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
A formula in a cell is different from a formula in conditional formatting. You can also use multiple formulae in conditional formatting.
ASKER
Flyster,
As I stated above I used "excels built in conditional formatting function but it seems awkward to have to format every single cell since I am using different formatting rules for each cell".
I tried highlighting a column and applying conditional formatting that way but selecting an entire column does not seem to work the way I want it to.
It is a bit cumbersome but it seems to work. I was hoping for an easier way to apply the format since I am doing an only several cells in an entire table.
As I stated above I used "excels built in conditional formatting function but it seems awkward to have to format every single cell since I am using different formatting rules for each cell".
I tried highlighting a column and applying conditional formatting that way but selecting an entire column does not seem to work the way I want it to.
It is a bit cumbersome but it seems to work. I was hoping for an easier way to apply the format since I am doing an only several cells in an entire table.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER