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.
0

Similar discussions

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

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

26 responses
Formula for conditional format to color cells
kipp2019 -
TrowaD -

14 responses
Conditional Formatting: 3 range of numbers
LCC -
LCC -

2 responses
Conditional formating - apply on more cells
Biljana -
Raj -

32 responses