A question on excel

I want to format a ce;; in a special way providing a particular criterion is met. For example, if I wish to change the colour of cell B5 and make the cell bold when cell A%is greater than A4 is there a way to do what I want?

I want to format a cell in a special way providing a particular criterion is met. For example, if I wish to change the colour of cell B5 and make the cell bold when cell A5is greater than A4 is there a way to do what I want?

Select the drop down box in Condition 1 and select the 'Formula Is' option.

Then in the Formula box that appears type the formula that you want to use.

From you example you would type:

=A5>A4

Click on the square button on the left hand side and you should return to the Condition 1 box.

Now you have set up the condition, all you need to do is select the format of the cell if A5 is greater than A4 - in your example it would be Bold font. Then select the 'Patterns' tab to choose the colour the cell will change to (red for example).

You can apply this to a number of cells, but you will need to highlight them first and repeat this process.

From your eg, I suspect it might be easier if the values in A4 and A5 were in the same row as the condition in B5 i.e. all your cells are in row 5.