Conditional Formating

local - Oct 3, 2009 at 08:53 AM
 Blocked Profile - Oct 4, 2009 at 06:17 AM
I have amounts in cells on a spredsheet that I want to add or minus to a total depending on the colour of the font. I have done this before but my pc crashed and I'm having to re-do all my sheets, and I cant remember how to do this. can anybody please help.

1 reply

Blocked Profile
Oct 4, 2009 at 06:17 AM
Dear Sir,

I will advise you to make an external back up copy if you have troubles with your PC.

In order to apply conditional formatting, just select the appropriate cell or cells and get to the Format menu.

You will hence see the Conditional Formatting option and the utmost end.

Select it and add the format conditions.

Thanks in advance.