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