Page 1 of 1
Forum

Welcome to the Tweaking4All community forums!
When participating, please keep the Forum Rules in mind!

Topics for particular software or systems: Start your topic link with the name of the application or system.
For example “MacOS X – Your question“, or “MS Word – Your Tip or Trick“.

Please note that switching to another language when reading a post will not bring you to the same post, in Dutch, as there is no translation for that post!



Excel - Conditional...
 
Share:
Notifications
Clear all

[Solved] Excel - Conditional coloring of cells

1 Posts
1 Users
0 Reactions
1,782 Views
 Hans
(@hans)
Famed Member Admin
Joined: 12 years ago
Posts: 2859
Topic starter  

Excel has a great option to conditionally color cells, for example a red cell when a value goes below a certain number, or a green cell when a number is positive etc. This can be done with a well hidden function in Excel: Format->Conditional Formatting.

You can configure your criteria very flexibly and it works instantly.


   
ReplyQuote
Share: