Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training in uk - Color Coding
excel training in uk - Color Coding
Resolved · Low Priority · Version Standard
Doron has attended:
Excel Intermediate course
Color Coding
I have seen excell sheets that automatically highlight a cell in red if the number is negative, and leave it in black if it is positive. How can I program this?
For upcoming training course dates see: Pricing & availability
RE: Color Coding
Hi Doron,
Thanks for the question.
These can be found if you go to Format-> Cells and the first tab number. If you look there you will see options where you can choose different colours for negative or positive values.
Good luck
Tracy
|
