Forum home » Delegate support and help forum » Microsoft Excel Training and help » 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. |
Conditional Formatting
Resolved · Medium Priority · Version 2003
Reply Wed 8 Feb 2012, 16:36Delegate John said...
John has attended:
Excel Advanced course
Conditional Formatting
I am using the following in Conditional Formatting to specify a particular condition - (Cell Colour)
"Formula Is" =(V$11:V$12)<1
If V11 is <1 and V12 is >1 then the condition is set, however if V11 is >1 and V12 is <1 then the condition does not get set.
Please advise what the formula should be to return the condition if either V11 or V12 is <1.
For upcoming training course dates see: Pricing & availability
RE: Conditional Formatting
=OR($V$11<1,$V$12<1)
try this
|