Previous Topic Next Topic

Conditional Formating

Closed
local - Oct 3, 2009 at 08:53 AM
 Blocked Profile - Oct 4, 2009 at 06:17 AM
Hello,
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.
Thanks

1 response

Answer 1 / 1
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.

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Conditional formatting based text in another cell
y88y -
y88y -

2 responses
Conditional formatting several cells risk register
oyvinols -
fdibbins -

1 response
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses