Forum home » Delegate support and help forum » Microsoft Excel Training and help » financial excel course london - Conditional formatting
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
financial excel course london - Conditional formatting
Resolved · Low Priority · Version Standard
Reply Thu 20 Sep 2007, 16:35Delegate Katie said...
Katie has attended:
Excel Intermediate course
Conditional formatting
I would really like to know how I would apply a conditional format to a row of data - i.e. if I have a list of values (revenue and costs) and the amount in the total column is 0 or less - how would I get the entire row to go red?
For upcoming training course dates see: Pricing & availability
Reply Fri 21 Sep 2007, 16:05Delegate Paul said...
RE: conditional formatting
Hi Katie,
for this example, let's say your total column is column E
first of all, in your total column, click format > conditional formatting then as the criteria of 'cell value is' type in <=0 and change the format to how you would like it
for the rest of your columns, highlight them all, go format > conditional formatting, change 'cell value is' to 'formula is'
then type =IF($E1<=0,TRUE,FALSE)
change the format to how you want it again, then you're sorted!!
Paul
|