View Single Post
 
Old 04-25-2021, 10:31 PM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

Here you go!

You create a separate rule for every condition;
You use formula as rule type;
In current situation, neither setting 'Stop if True' or changing rules order doesn't affect the result, as there is no way several conditions are true for same field.
Attached Files
File Type: xlsx ConditionaFormatExample.xlsx (10.3 KB, 8 views)
Reply With Quote